Excel - Compare two lists for what's missing in one? 1

[hneal98]

Does anyone know if there is a way to compare two lists and find all items in one that is not in another? I prefer not to use VBA, but if I must, i will.

Thanks in advance.

 

[coachdan]

Why not Put the 2 lists in Access in separate tables and then do a Unmatched Query to find the differences? It would take just a couple of minutes to find out.

coachdan32

http://www.malehsbaseball.com

 

[firefytr]

Take one list and find a blank column adjacent to it (I'll assume that is on Sheet1 and assume the other sheet is Sheet2). Enter this formula ...

=COUNTIF(Sheet2!A:A,A1)

This also assumes your data starts on row 1 and the column to check is in A of Sheet2. Change desired variables to suit. Everything with a number is found on the other sheet.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[hneal98]

Thanks for your reply...

Because it is on another server that does not have access.