T
Theresa
I need to compare two columns of numbers and return what doesn't match. What
formula would I use?
formula would I use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
=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
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
P
Pete_UK
You're welcome - thanks for feeding back.
Pete
Pete
Thanks Pete, works great!
- Show quoted text -