Compare one cell to another

[bbrodsky]

I have two colums of numbers. They are sorted in decending order. I need to
match the numbers and find out if there are any non-matching numbers in
either colum.

 

[Bob Phillips]

Just use

=IF(A2=B2,"","No match")

and copy down

 

[Dave Peterson]

I'd use a formula in another column.

Say in B1:
=isnumber(match(a1,c:c,0))
and drag down as far as column A is used.

You'll see True if there's a match anywhere in column C for the value in A1.
You'll see False if there is no match.