Find and Delete duplicates in Excel

[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

 

[Frank Kabel]

Hi
use 'Data - Filter - Advanced Filter' and check 'Unique
entries'

 

[Dan Aja]

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

 

[Frank Kabel]

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

 

[Gord Dibben]

Dan

Also check "copy to another location".

For more on this, see Debra Dalgeish's site.

http://www.contextures.on.ca/xladvfilter01.html

Note links at 1. a and b

Gord Dibben Excel MVP