View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default 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