how to compare two columns. Closed

Question

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....

Configuration: Windows XP / Internet Explorer 7.0

Trowa · Answer

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

How to compare two columns.

1 response

Similar discussions

Subscribe To Our Newsletter!