Compare values in two columns

  • Thread starter Thread starter Rubi
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Try this in row 1 and fill down:

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

HTH
Jason
Atlanta, GA
 
Back
Top