Comparing two files

C

ChrisM

I'm trying to find a way of comparing two excel files that are lists of
e mail addresses, 1 has about 20k the other newer file has about a
1000. I need to weed out any duplicates before merging the two files.
Any help or suggestions would be much appreciated
 
J

Jan Putcuyps

You can match the 2 lists by using the vlookup formula. Then you select the
ones showing up #N/A and merge them with the other list. I think this is
wat you are trying to achieve?

Regards,
Jan
 
C

ChrisM

Thanks Jan, but does this compare the two files for duplicates or just
the individual files for duplicates within that file. If it compares
the two files I'm obviously typing in something wrong.
regards
Chris
 
J

Jan Putcuyps

I will try to explain it in a more clear way.

Let's say your bigger, older list = ListA , and the new smaller one = ListB

Now you want to check if an address in ListA is used in your new ListB.
Your formula in the big sheet should be something like this then:

=vlookup(A1;[listB.xls]Sheet1!$A$1:$A$1000;1;false)

If you fill this down, the addresses next to #N/A are not being used in the
new list.

You can also use the countif function if you want to know how many times the
address is listed in the other sheet. You should formulate something like:

=countif(ListB;A1)

Let us know if it works out for you.

Regards,
Jan
 
Top