Remove Duplicates; How can I get a list of items removed?

G

Guest

Its good to remove the duplicates. However, I would lilke to get a list of
the duplicates that were removed. How can I get this list?
 
P

Peo Sjoblom

Use the original list and then compare them with a simple is formula
appended to the original list, so if the original list is in A2:A500, then
insert temporarily a blank B column or use the one that exists if it is
empty, assume the list w/o duplicates are in Sheet2!A2:A480

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

copy down the formula, then apply data>filter>autofilter (make sure you have
headers) and filter on B for TRUE, then just copy the filtered list
somewhere else, that is the list with duplicates
 

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

Removing duplicates - Excel 2007 2
remove duplicates problem 1
Display only duplicate values and delete UNIQUE Items 2
Removing Both Duplicates from a list 11
is there a simple formula that will remove all duplicates in a simple list 1
Calculating duplicates 2
How can I count dates if few duplicates in a column 3
Duplicates Excel 2000 2

Top