comparing
 

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 ?

comparing
 

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))

--
Best Regards,

Luke M
"pierre" wrote in message
...
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 ?

comparing
 

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

"Luke M" wrote:

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))

--
Best Regards,

Luke M
"pierre" wrote in message
...
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 ?



.