'De-duplication' of Excel file (Group by)

Edhurn · Aug 13th 2004

I am attempting to remove all duplicate rows from a large Excel spreadsheet (without putting into Access). Is there an Excel equivalent of the GROUP BY clause?

Any help much appreciated.
Thanks

Anonymous · Aug 13th 2004

You can sort the data by three columns at a time, but a better way to eliminate duplicate rows is to use an Advanced Filter (under the Data menu) to copy unique records to another location.

'De-duplication' of Excel file (Group by)

Participate now!

Share