Home |
Search |
Today's Posts |
#1
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
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
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 ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing | Excel Worksheet Functions | |||
Comparing more than two | Excel Worksheet Functions | |||
Comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
Comparing Text | Excel Worksheet Functions | |||
Comparing two tables | Excel Discussion (Misc queries) |