deduplication

J

JMay

If your Data is in Column A , beginning in Cell A2
enter the following fomula in B2 and Copy down

=COUNTIF(A$2:A2,A2)>1

You will see True/False; All that are True are Duplicates
Suggest you do an AutoFilter Selecting True; and while
filtered, Delete all Selected Rows. Then Unfilter
 
G

Gord Dibben

Excel 2003.............Data>Filter>Advanced Filter.

Unique records only and copy to another location.

Excel 2007.............Data>Sort and Filter>Advanced Filter


Gord Dibben MS Excel MVP
 
Top