Comparing Data in 2 columns

S

suzb

I'm comparing data in 2 columns. I need to find unique cells that are located
in Column B that are not in column A.
 
M

Myrna Larson

In column C, put this formula:

=IF(COUNTIF($A$2:$A$100,B2)=0,"X","")

and copy it down

This will show an X next to the items in column B that aren't in column A.
 
Top