MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting rid of duplicate data

Posted by Dan on August 01, 2001 9:25 PM

I have a spreadsheet with about 5000 rows of data. How can I sort thru this to get rid of the duplicate rows of data ... One column should have unique data in each cell ... if the data is duplicated in this column then I need to throw out the duplicate row of data so that that column contains only unique data. How can I do this?

Posted by Richard S on August 01, 2001 9:34 PM

You could try using Data, Filter, Advance filter, and click the unique records only box. This will provide only unique records based on all the data. If you only want to remove records that have duplicates in a particular column, that's a different matter.