=IF(A1<B1,"Not the same","")

and copy down.

--
HTH

Bob Phillips

"Jim" wrote in message
...
I have two columns a nd b. I have numbers in both columns. I need a
formula
to compare both columns and idenify the amounts that are not the same in
both
columns.