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.