How do I remove duplicates in Excel?
How do I remove duplicates in Excel?
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!
- hal_nesbitt
- Site Admin
- Posts: 32
- Joined: Thu Jul 24, 2003 5:53 pm
- Location: Alexandria, VA
- Contact:
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'
"Maturity is stupid." - Benjamin Franklin
Who is online
Users browsing this forum: No registered users and 1 guest