Compare one cell to another

B

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.
 
D

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.
 
Top