Posted to microsoft.public.excel.misc
|
|
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
|