PC Review


Reply
Thread Tools Rate Thread

comparing 2 columns

 
 
rodchar
Guest
Posts: n/a
 
      24th Jun 2009

hey all,

i have 2 columns and i want to compare row-by-row if they are the same or
not. is there a way to do this?

1,1 the same
1,2 different
2,2 the same

thanks,
rodchar
 
Reply With Quote
 
 
 
 
Max
Guest
Posts: n/a
 
      24th Jun 2009

In C2, copied down: =IF(A2<>B2,"different","same")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"rodchar" wrote:
> i have 2 columns and i want to compare row-by-row if they are the same or
> not. is there a way to do this?
>
> 1,1 the same
> 1,2 different
> 2,2 the same


 
Reply With Quote
 
rodchar
Guest
Posts: n/a
 
      24th Jun 2009

thanks for the help,
rod.

"Max" wrote:

> In C2, copied down: =IF(A2<>B2,"different","same")
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:25,000 Files:300 Subscribers:70
> xdemechanik
> ---
> "rodchar" wrote:
> > i have 2 columns and i want to compare row-by-row if they are the same or
> > not. is there a way to do this?
> >
> > 1,1 the same
> > 1,2 different
> > 2,2 the same

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing columns Dave T Microsoft Excel Worksheet Functions 1 23rd May 2009 10:27 AM
comparing two columns JoeM Microsoft Excel Worksheet Functions 5 1st May 2009 07:12 PM
Need elp comparing two columns in VBA lenarei.vitocruz@gmail.com Microsoft Excel Programming 0 27th Aug 2007 03:57 PM
Comparing 2 columns if they are the same Faio Microsoft Excel Worksheet Functions 4 15th Nov 2005 10:18 AM
Comparing 2 columns lynn Microsoft Excel Worksheet Functions 1 29th Jan 2004 09:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:44 PM.