I have two workbooks from different programs which I imported to Excel. I
need to compare them to see what clients are on/off the lists. Some clients
have duplicate names because they have two different tests and I only want
to count them once to compare them to the other list to make sure they are on
that list.

Overall, I want to know if each client is on both lists and if not to to
make another list for the clients that are not on both lists.

Thanks,
Kathy