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

Need Help with a VBA subroutine 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
comparing sheet to sheet and adding value 1
VBA Coding Help for Beginner 0
List all tables, including document structure 0

Top