MrExcel.com - Your One Stop for Excel Tips & Solutions

Deleting Like Rows?

Posted by Chris Whisonant on October 03, 2000 7:58 AM

I have a spreadsheet about 1500 rows long. Much of the data is repetitive. I have 5 columns (user, company, level, number, and description. I need to go through this and either delete or hide all the rows that are duplicates while leaving the original. I have tried using Access to find duplicates, but this does not leave the rows that do not have duplicates.

Any help is greatly appreciated,
Chris Whisonant

Posted by Doug on October 03, 2000 11:16 AM

Try using the Advanced Filter Command. Select all of your data, then choose Data | Filter | Advance Filter. Save the data to a new location and be sure to select "unique records only" (no criteria needed)