comparing 2 columns

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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