matching and eliminating duplicate data

  • Thread starter Thread starter kath
  • Start date Start date
K

kath

I need to be able to find the function that compares two
documents, find the duplicated clients and eliminate them
on both documents, leaving only the unique names.

For example,
I have a list of 1000 names exported May 10 from another
database software we use for inputting client
information. I sent all 1000 clients a letter.

On June 3, I received another list exported that contains
1400 clients, 400 more in additon to the May 10 list names
in alphabetical order.

Is there a way for me to copy and past the two files and
tell it while it is copying to get rid of the original
1000 and leave me with the new 400? So I don't have to
use a pen to cross them out while comparing one name on
one list against the other?

Thanks a million!
 
Assuming the original list is on Sheet1, with name in column A, header in row 1, new list is on
Sheet2, name in column A, header in row 1...

On Sheet2, in a column on the right, say K2, put the formula =COUNTIF(Sheet1!A2:A1000,A2) and
copy it down through K1401.

Then use AutoFilter on column K to select rows where the value is 0. Copy these rows and paste
to a new location.
 
Back
Top