Excel Duplicates

  • Thread starter Thread starter lisamarieduncan
  • Start date Start date
L

lisamarieduncan

I have a list with many duplicates. Is there a way to delete all of the
duplicates except for the one?
 
Rename the one you want to keep. filter on rest of dups, delete
 
Is this Office 2007? If so, there is a function on the Data tab under Data
Tools called Remove Duplicates that will allow you to select a column to
remove the duplicate rows from.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
remove duplicates but retain one not delete both 4
Best solution to merge multiple Outlook contacts easily 2
Best Gmail Backup Tool to use in 2025? 3
Duplicate Rows 2
Counting number of items excluding duplicates. 1
How do I remove all records of duplicated fields? 3
delete all dulplicate rows leaving no record of the duplicates 3

Back
Top