Re: Comparing two files
- From: Jan Putcuyps <jan.putcuyps@xxxxxxxx>
- Date: Thu, 15 Jun 2006 15:52:44 +0200
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:
If you fill this down, the addresses next to #N/A are not being used in the
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:
Let us know if it works out for you.
On 15-06-2006 12:18, in article
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.
Jan Putcuyps wrote:
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?
On 14-06-2006 18:55, in article
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
- Prev by Date: Re: Change axis lengths? Tick marks but NO axes?
- Next by Date: Re: Need help with date input
- Previous by thread: Re: Comparing two files
- Next by thread: AppleScript and Office 2007