Find and Delete duplicates in Excel

  • Thread starter Thread starter Dan Aja
  • Start date Start date
D

Dan Aja

I am new to Excel. In an Excel spreadsheet is there a way
to automatically search the list for all duplicate terms
and delete the duplicates. I am developing a list of
medical codes and after compiling the list with over
20,000 terms, I need to quick way to identify and delete
duplicate terms.

Dan
 
Hi
use 'Data - Filter - Advanced Filter' and check 'Unique
entries'
 
When I select a column and then 'Data - Filter - Advanced
Filter' and check 'Unique Records and filter in place,
nothing happens. The duplicates remain in the column.
Any other ideas?

Dan
 
Hi
this should not happen :-) Are you sure they're really identical?. Also
try to output the values in a different area of your sheet
 
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
Identify (not delete) exact duplicates 1
locating and deleting duplicate cell entries 2
Removing Duplicates to another sheet 1
remove duplicates but retain one not delete both 4
Deleting Duplicates 3
Delete duplicate and original row 3
Entire Row Duplicates 6

Back
Top