I have two very long lists of student names in one worksheet. The names in
A1:A500 is the master list. The student names in B1:B200 have successfully
passed their exam. I would like to know which student names are NOT in the
second list by comparing it to the master .
A1:A500 B1:B200 Answer= John and Steve
Joe Joe
John Sally
Steve
Sally