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 - Download - File management
Display two columns in data validation list but return only one - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum
How to compare two columns in excel for partial matches - 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

Extract identical cells of 2 columns (excel)

Macro to compare 2 sheets and copy differences

VBA Compare 2 sheets and output difference to 3rd sheet

Similar discussions

Subscribe To Our Newsletter!