How to compare two coloumns in excel

Solved/Closed
vijay - Apr 11, 2009 at 10:13 AM
 jhanvi - Jul 4, 2013 at 02:16 AM
Hello,

2 replies

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Apr 12, 2009 at 06:25 AM
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
if only all my life were so simple! This is the best most simple solution!!!
0
This really worked and made my life easier ..... thanks for the EXCELlent tip :)
0
What if the data are not exactly on the same row this does not work is there a way to compare the data now?
0
Thank you very much. Direct Answer without any unnecessary stuff.
0
and a simple formula at that. Thanks!
0
Same thing if I have to compare three columns what to do ?
9