compare two lists

Hi,

You may try this array formula (Ctrl+Shift+Enter):

=if(or(exact(A1,$B$1:$B$50)),"",A1)

and copy downwards

A1 is from list 1. $B$1:$B$50 is list 2

Regards,

Ashish Mathur

"rob p" wrote:

> I can export a client list from our 2003 and 2004 tax systems. They are in
> xls format. Is there a way to run a compare on the name field in Excel and
> generate a report showing unique names in both lists. I don't care about
> matches. Or is there a way to get them into Access to do the same thing?
> Thanks.
>
>
>

I want to try this. First, is my first list A1 down? And then is my second
list B1 down? (and this means a total of 50 records?) ( I actually have
about 1,200 of them.)

Do I load one list in column A1 and then copy and paste in the other list
to the second column? I'm not quite sure of what I need to do.
Thanks.



"Ashish Mathur" <mathurashish@hotmail.com> wrote in message
news:8D05C2F0-D68E-4493-9D2B-8B7D07039D36@microsoft.com...
> Hi,
>
> You may try this array formula (Ctrl+Shift+Enter):
>
> =if(or(exact(A1,$B$1:$B$50)),"",A1)
>
> and copy downwards
>
> A1 is from list 1. $B$1:$B$50 is list 2
>
> Regards,
>
> Ashish Mathur
>
> "rob p" wrote:
>
> > I can export a client list from our 2003 and 2004 tax systems. They are
in
> > xls format. Is there a way to run a compare on the name field in Excel
and
> > generate a report showing unique names in both lists. I don't care about
> > matches. Or is there a way to get them into Access to do the same thing?
> > Thanks.
> >
> >
> >