One more thing. Be sure you have your range formatted the same for text and
numbers.

"CM" wrote:

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