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.

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Easydoesit" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>