Re: Comparing two files


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



On 15-06-2006 12:18, in article
1150366685.444869.164320@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, "ChrisM"
<chris@xxxxxxxxxxxxxxxxx> wrote:

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

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?

Regards,
Jan


On 14-06-2006 18:55, in article
1150304127.009840.196430@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, "ChrisM"
<chris@xxxxxxxxxxxxxxxxx> wrote:

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




.

Relevant Pages

  • Re: Newbie: Struggling again map
    ... return fillchars ... map(maketuple, lista, listb) ... # how many non-exhausted iterators are left ...
    (comp.lang.python)
  • Re: Systematically Renaming Ranges
    ... sort the data and use defined names for your data source ... Refersto = =Offset,1) ... Use the names ListA and ListB as your data sources. ...
    (microsoft.public.excel.programming)
  • Re: Compare methods
    ... foreach (string s in ListA) { ... foreach (string s in ListB) { ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TStringList.assign and objects
    ... > Let's say that I have two TStringLists: ListA, and ListB. ... > ListA with some strings and associated Objects. ... > ListB's Objects will result in access violations. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Inconsistent list/pointer problem
    ... the first time that I call a function and never happens on subsequent ... passing in a list as the input data. ... listB = listA ... work on & modify listB ...
    (comp.lang.python)