Display unique values from two columns

  • Thread starter Thread starter Laura C
  • Start date Start date
L

Laura C

I have two columns of values (in which there are some
duplicate values and want to compare the two and only
display non-duplicates. I was trying to use the formula in
column D against all of Column C values

=IF(C2<>B$2:B$2361,C2,"")

Therefore my thinking being that in column D that either
there will be the value or a blank and I can filter or
sort accordingly to have a new list of unique values.

However it is not picking up the range B2-B2361, only the
cell on the corresponding row to where the formula is
entered i.e. w.r.t above it is only looking in B2.

Any help or possible solutions please.
Kind regards
Laura
 
Laura
Using command Data->Filter_> Advanced filter and checking "unique records" I
can eliminate the duplicates
 
Hi,

If you want to compare the values in C column against the ones in B
column and return the non-duplicates alone, then use

=IF(COUNTIF($B$2:$B$2361,C2)>0,"",C2)

Regards

Govind.
 
Back
Top