compare different workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing two worksheets 1
Ms outlook export. 0
Excel Comparing two columns 1
Compare two workbooks and hi-light matches 0
Comparing and removing data in different workbooks 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Lookup values, compare and paste 1
Compare text in 2 different files 2

Back
Top