Posted to microsoft.public.excel.misc

rodchar

external usenet poster

Posts: 80

comparing 2 columns

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
comparing columns	mel	New Users to Excel	2	November 20th 07 02:44 PM
comparing two columns	mouhammmmmmmad	Excel Discussion (Misc queries)	1	January 19th 07 10:46 PM
Comparing two columns of information with 2 new columns of informa	cbuck	Excel Discussion (Misc queries)	1	January 16th 07 09:49 PM
comparing columns	~Q	Excel Worksheet Functions	1	November 17th 05 07:41 PM
Comparing 2 columns if they are the same	Faio	Excel Worksheet Functions	4	November 15th 05 10:18 AM

All times are GMT +1. The time now is 12:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us