That formula disregards case and leading or trailing spaces. So be careful
how you use it. You might want to know if there are spaces in a cell since
they have a value in computer speak. If you want to capture those
differences, then eliminate the TRIM portion of the formula.

"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