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" wrote in message
...
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.