How do I remove duplicates in Excel?

Questions about running any kind of software, such as how-to's and fixes for MS Office, Adobe Acrobat, etc., or how to do stuff in Windows.
Post Reply
Posts: 2
Joined: Tue Feb 05, 2008 12:28 am

How do I remove duplicates in Excel?

Post by dlee » Tue Feb 05, 2008 12:31 am

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!

User avatar
Site Admin
Posts: 32
Joined: Thu Jul 24, 2003 5:53 pm
Location: Alexandria, VA

Post by hal_nesbitt » Wed Feb 06, 2008 11:41 am

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!
"Maturity is stupid." - Benjamin Franklin

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest