Compare values in two columns

[Rubi]

I need to find values in column B that are not in column A.
I merged the two columns into one column and used Advanced
Filter, unique values, but Excel just dropped the
duplicates. It did not give me the real unique values in
the combined list.
I researched VLookup but I do not think it will return what
I need.

 

[Anon]

I need to find values in column B that are not in column A.
I merged the two columns into one column and used Advanced
Filter, unique values, but Excel just dropped the
duplicates. It did not give me the real unique values in
the combined list.
I researched VLookup but I do not think it will return what
I need.

One way:
In C1 put the formula
=ISNA(MATCH(B1,A:A,0))
and copy down as far as there is data in column B. Unique values will be
marked with TRUE.
You can then sort on this column to get them all together if you wish.

 

[Jason Morin]

Try this in row 1 and fill down:

=IF(COUNTIF(A:A,B1),"","Not Found!")

HTH
Jason
Atlanta, GA