compare two columns

T

Theresa

I need to compare two columns of numbers and return what doesn't match. What
formula would I use?
 
K

Kevin B

Assuming data in Columns A & B with the formula in Column C:

=IF(A1<>B1,"No Match","")

or if you prefer a True/False

=IF(A1<>B1,False,True)

Adjust column and rows as needed and copy down as far as necessary.
 
P

Pete_UK

If you want to see if any of the numbers in column A match with any of
the numbers in column B, then put this in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"No match","")

Copy this down as far as necessary to cover your numbers.

Hope this helps.

Pete
 
T

Theresa

Thanks Pete, works great!

Pete_UK said:
If you want to see if any of the numbers in column A match with any of
the numbers in column B, then put this in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"No match","")

Copy this down as far as necessary to cover your numbers.

Hope this helps.

Pete
Click to expand...
 

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 2 columns 6
compare two columns and pull out differences 1
Comparing results of two formulas 2
compare 2 columns of numbers and place the matched numbers in a 3r 5
Comparing Cells 1
Comparing two matrices 1
comparing two columns 2

Top