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
 

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

deduplicate data in excel 8
list duplicates 2
how do you de-dup an address list in Excel? 2
Using EXACT to Deduplicate 4
Copying a formula in a blank column as far as data in previous column 1
Duplicates within a cell 9
SELECT DISTINCT query is not deduplicating 2
ETL tool in foreign languages 4

Back
Top