• Notice regarding image hosts and attachments. See here.

Another excel question

Soldato
Joined
16 Oct 2007
Posts
7,511
Location
UK
Because you lot are awesome.





Is it possible, to remove duplicates from a sheet?

I have Columns A -> F

I want to remove the row if the value in column A is duplicated.

I've sorted by values, so all the duplicates are grouped - but there's about 5,000 rows!

Thank you
 
Data > Filter > Advanced Filter... Set your grouped range (maybe one group at a time if not many of them) and tick 'Unique records only'.
 
If you want to remove the duplicate values then as Nanobot posted. However if you want to remove/move all the duplicated rows (both the original and the duplicates(s)) you can create another column and insert the formula =countif(A:A,A). Sort the sheet on this column and remove/move all rows where the new column is greater than 1.
 
Back
Top Bottom