ExcelBanter - comparing 2 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - comparing 2 columns (https://www.excelbanter.com/excel-discussion-misc-queries/234831-comparing-2-columns.html)

rodchar

comparing 2 columns

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

Max

comparing 2 columns

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

rodchar

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

All times are GMT +1. The time now is 03:51 PM.