Compare one cell to another
 

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.

Compare one cell to another
 

Just use

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

and copy down

--
__________________________________
HTH

Bob

"bbrodsky" wrote in message
...
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.

Compare one cell to another
 

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.


bbrodsky wrote:

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.

--

Dave Peterson