Check http://www.j-walk.com/ss/excel/usertips/tip027.htm

OR http://www.j-walk.com/ss/excel/usertips/tip048.htm

--
Rani


"Faio" wrote:

I have two columns to compare. I first sort them out in the same order and
then use the IF function. The If function is OK but when the rows to compare
are not match due to the error in typing or spaces then there is no match.
Is there another way or function to use that instead of sorting, it will
just lookup the two columns and compare and then indicate that there are say
5 mismatched and indicate them?

Appreciate any help

JSSU0611220
JSSU0611220

JSSU0618924
JSSU0611339

JSSU0617893
JSSU0612227

JSSU0615170
JSSU 0614195

JSSU0614370
JSSU0614322

JSSU0614322
JSSU0614370

JSSU0614195
JSSU0615170

JSSU0612227
JSSU0617893

JSSU0611339
JSSU0618924