How to compare between 2 columns ?

Y

Yoav

Need help with comparing between 2 columns in Excel.
In my case I have 2 columns, each in a different sheet,
that I want to compare.
I use the EXACT function but I see that in sheet1:A30 the
value is different from sheet2:B30 but I get TRUE...
I need a function that will compare 1 by 1 the values in
the 2 different columns.
 
R

Richard O. Neville

You could use an IF function; =IF(B2=C2,1,0). This means that if cell B2
equals cell C2, the check cell will show the number 1; if not equal, the
number 0. You can also use text if in quotes: =IF(B2=C2,"Same","Different").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Comparing values in columns 2
Compare identifier columns from 2 sheets - remove rows that are dups 2
OR Exact statement not working to compare values in two columns 4
Compare data (2 columns) from 2 worksheets within a workbook 2
VBAscript for data matching excels 0
lookup with multiple condition, but one condition to satisfy is en 2
Duplicate Values in Excel 2007 6

Top