compare cells in two columns

E

Easydoesit

I'm trying to figure out how to get Excel to compare data in two columns and
flag cells that are not in the other column.

Thanks,

Dave H.
 
M

Max

One way ..

Assuming the "master" data list is in col A, A1 down,
and the other data is in col B, B1 down

you could put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"","x")
and copy C1 down until the last row of data in col B

Col C will flag an "x" for those data in col B not found in col A
 
Top