Previous Topic Next Topic

How to compare two columns.

Closed
THIRU - Sep 1, 2010 at 06:15 AM
 Trowa - Sep 2, 2010 at 09:23 AM
Hello,

i have excel sheet with more columns with applied more formulas. now i want to compare two columns values are equel or not, that rusult should show in separate column like true (in case equel) or false (incase not equel)

pls advice....

Related:

1 response

Answer 1 / 1
Trowa
Sep 2, 2010 at 09:23 AM
Hi THIRU,

If you want to compare Column A with Column B then use the following formula in C1:
=IF(A1=B1,"True","False")
Now drag it down as far as needed.

Best regards,
Trowa

Similar discussions

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
How to compare two different columns
ABACUS -
TrowaD -

1 response
compare and count
vinod -
pcsces -

1 response
Compare Fields
Swapnil Arjun Veer -
Mazzaropi -

1 response
How to Compare two workbooks and see if data has moved or not?
hoosier1851 -
TrowaD -

1 response