compare two columns
Thanks Pete, works great!
"Pete_UK" wrote:
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
On Apr 11, 9:23 pm, Theresa wrote:
I need to compare two columns of numbers and return what doesn't match. What
formula would I use?
|