comparing

[pierre]

hi all
i have a list of data in column A and B... i.e
A1 : pete rose B1 : pete sam rose (they are the same person)
A2 : amber kerr B2 : amber dawn saly kerr (they are the same person)

i am comparing these two by using =exact(..) , but the result is false
although its true. any suggestions ?

 

[Luke M]

How would XL know they are the same person???

If you're really only wanting to compare first and last names...
=AND(LEFT(A1,FIND(" ",A1)-1)=LEFT(B1,FIND(" ",B1)-1),
MID(A1,FIND(" ",A1)+1,999)=MID(B1,FIND("xxx",SUBSTITUTE(B1,"
","xxx",LEN(B1)-LEN(SUBSTITUTE(B1," ",""))))+1,999))

 

[reza]

Luke

I have same problem like pieere..
i.e
A1 = Reza Aditia B1= rezaaditia

i tried with ur formula below, but doesn't work..can you share ur formula 4
me..

thanks