|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 5th, 2010, 08:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? 
|
|
#2
May 5th, 2010, 09:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ?
|
|
#3
May 6th, 2010, 06:02 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
