How to compare two coloumns in excel [Solved/Closed]

Report
-
 jhanvi -
Hello,

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
In a new column, put =cell1=cell2 and drag this to the end Eg Two compare column1 & column2, in cell(A3) put '=A1=A2' If both the values are same, TRUE will be displayed. To find FALSE search for FALSE
28
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

and a simple formula at that. Thanks!
Simple and Excellent....Great Work Buddy
Exellant guru.. simpel but power full
thanks it helped me
thanks for ur help
Same thing if I have to compare three columns what to do ?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!