Compare 2 columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaz - 21 Nov 2006 17:15 GMT

I have 2 columns that I want to compare. Want column 1 to see if there is a
matching number in column 2. Then, I want the third column to say 'Match'
so I can identify which ones match.

How would I do this?

Thanks,
Jasper

Reply to this Message

Nick Hodge - 21 Nov 2006 20:24 GMT

Japser

Something like...

IF(A1=B1,"Match","")

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

>I have 2 columns that I want to compare. Want column 1 to see if there is
>a
[quoted text clipped - 5 lines]
> Thanks,
> Jasper

Reply to this Message

Dave Peterson - 21 Nov 2006 20:29 GMT

Put this in C1:

=if(isnumber(match(a1,b:b,0)),"Match","No Match")

And drag down as far as column A is used.

> I have 2 columns that I want to compare. Want column 1 to see if there is a
> matching number in column 2. Then, I want the third column to say 'Match'
[quoted text clipped - 4 lines]
> Thanks,
> Jasper

Signature

Dave Peterson

Reply to this Message

Rate this thread: