Compare values in two columns


R

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.
 
Ad

Advertisements

A

Anon

Rubi said:
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.
 
Ad

Advertisements

J

Jason Morin

Try this in row 1 and fill down:

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

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top