Previous Topic Next Topic

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,
Related:

2 responses

Answer 1 / 2
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
jr
Apr 14, 2010 at 11:42 AM
if only all my life were so simple! This is the best most simple solution!!!
0
cheechu
May 5, 2010 at 01:59 AM
This really worked and made my life easier ..... thanks for the EXCELlent tip :)
0
Nonguru
Jun 8, 2010 at 08:22 AM
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
Ram
Jun 18, 2010 at 05:32 PM
Thank you very much. Direct Answer without any unnecessary stuff.
0
Heffe
Jul 22, 2010 at 02:31 PM
and a simple formula at that. Thanks!
0
Answer 2 / 2
Sri
Nov 10, 2009 at 03:03 AM
Same thing if I have to compare three columns what to do ?
9

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response