Page 1 of 1

How do I remove duplicates in Excel?

Posted: Tue Feb 05, 2008 12:31 am
by dlee
I have an excel document that I need to dedupe (remove the duplicates) from one column. Is there a quick and easy way to do this in excel? There are several hundred records and I do not want to have to go through them one by one. Thanks in advance!

Posted: Wed Feb 06, 2008 11:41 am
by hal_nesbitt
Sure thing! Excel has a built in function to do just that. Just select the column or data you want to sort and then:
  • Go to Data > Filter > Advanced Filter
  • Click 'Copy to Another Location' under 'Action'
  • Check 'Unique Records Only'
  • Enter the range of records in the list range and critera range
  • In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don't overwrite pre-existing data.
  • Hit 'Ok'
Note: you can only do this in the active sheet. This should save you a lot of time though, and is quite useful!