deduplication

  • Thread starter Thread starter scavvie
  • Start date Start date
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
 
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
 
Back
Top