Thread: Compare 2 columns and put unique data in column 3
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] elaine216@gmail.com is offline
external usenet poster
  
Posts: 14
Default Compare 2 columns and put unique data in column 3
On 7 Mar, 12:13, Toppers wrote:
This willputuniquenames in A incolumnC.

Putin C1 and opy down for your range incolumnA

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

HTH



" wrote:
Hi,

I have twocolumnsofdata, they are all names.

ColumnA contains all the names whilecolumnB only contains some of
the names whichcolumnA has. I want to find out theuniquename which
ColumnB havent got but A has, andputit inColumnC, is there a way
to do it?

Thanks.
Elaine.- Hide quoted text -

- Show quoted text -

thanks! it works !!

Reply With QuoteReply With Quote