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

How to compare two columns.
Beyond compare - Download - File management
Display two columns in data validation list but return only one - Guide
Tweetdeck larger columns - Guide
Excel compare two sheets - Guide
How to remove columns in word - Guide

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

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

formula if you have credit in one column, debit in next column

Auto generate serial number in excel based on Column

Similar discussions

Subscribe To Our Newsletter!