Microsoft Office Forums


Reply
Thread Tools Display Modes

Compare 2 columns

 
 
Jaz
Guest
Posts: n/a

 
      11-21-2006, 04:15 PM
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 With Quote
 
 
 
 
Nick Hodge
Guest
Posts: n/a

 
      11-21-2006, 07:24 PM
Japser

Something like...

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
www.nickhodge.co.uk


"Jaz" <(E-Mail Removed)> wrote in message
news:uJr%(E-Mail Removed)...
>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 With Quote
 
Dave Peterson
Guest
Posts: n/a

 
      11-21-2006, 07:29 PM
Put this in C1:

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

And drag down as far as column A is used.

Jaz wrote:
>
> 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


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
compare 2 columns sndesai74@gmail.com Excel Newsgroup 3 04-24-2006 08:00 PM
Compare two columns datas Franck Excel Newsgroup 1 04-18-2005 09:57 AM
Compare 2 columns in a spreadsheet Sam Excel Newsgroup 1 04-02-2005 01:58 AM
Compare columns TerryM Excel Newsgroup 2 06-18-2004 10:39 PM
Compare data in columns Beth Excel Newsgroup 0 07-07-2003 05:33 PM



All times are GMT. The time now is 02:10 PM.