View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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.