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

The VLOOKUP feature will check a cell against a list to see if it matches,
but will not find Thomas Jones if you look up Tom Jones, and vice
versa.........comparing lists from different sources is a bit of a problem
because they don't usually format everything the same.


Vaya con Dios,
Chuck, CABGx3




"kjstec" wrote:

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