Need to compare 2 columns and find missing names

[DEllis]

Hi Everyone, I have Last name, First Name in A2 and I have Last Name, First Name in B2. How do I compare to see if there are any missing names? So in other words Column A 463 entries and column B has 450, I need to determine where there are no matches.

 

[Joe4]

There are numerous ways.
You could use MATCH, VLOOKUP, or COUNTIF formulas to see if a value is found in the other list.
I would probably recommend MATCH.

So, if you wanted to see if the value in A2 is found in column B, you could use the formula:

=IF(ISNUMBER(MATCH(A2,B:B,0)),"Matched","Unmatched")

and copy down for each cell in columns A.

And then just to the reverse to check to see if B2 is found in column A.