Another excel question

[tres]

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

 

[Nanobot]

Data > Filter > Advanced Filter... Set your grouped range (maybe one group at a time if not many of them) and tick 'Unique records only'.

 

[Thrash]

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.