Compare 2 columns and put unique data in column 3

[elaine216]

Hi,

I have two columns of data, they are all names.

Column A contains all the names while column B only contains some of
the names which column A has. I want to find out the unique name which
Column B havent got but A has, and put it in Column C, is there a way
to do it?

Thanks.
Elaine.

 

[Guest]

This will put unique names in A in column C.


Put in C1 and opy down for your range in column A

=IF(COUNTIF(B:B,A1)=0,A1,"")

HTH

 

[elaine216]

This willputuniquenames in A incolumnC.

Putin C1 and opy down for your range incolumnA

=IF(COUNTIF(B:B,A1)=0,A1,"")

HTH








- Show quoted text -

thanks! it works !!