How to compare two columns. [Closed]

Report
-
 Trowa -
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....

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!