Display unique values from two columns

[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

 

[Nitin Harkawat]

Laura
Using command Data->Filter_> Advanced filter and checking "unique records" I
can eliminate the duplicates

 

[Govind]

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.