Depends what the data is. Could it be a real number compared to a text
number ? Or maybe trailing spaces. Depends how you get the data.

Regards

Trevor


"CM" wrote in message
...
I am trying to compare two columns of data to find identical data, i'm
using
the formula below and when it is supposed to be same it says different, in
some areas the formula works right in others it doesn't. any ideas on what
the problem is

IF(A1=B1,"SAME","DIFFERENT")

thanks for the help