Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match similar names
A1 B1
Frank Mark Allen Frank Mark Allen Frank Mark I want to compare two cells. A1 contain full name , B1 contain short name . searching for formula to do a minimum match. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match similar names
This might work for you...Try the below formula in cell C1...
=IF(ISNUMBER(SEARCH(B1,A1)),"Probable Match","No match") -- Jacob "Sam" wrote: A1 B1 Frank Mark Allen Frank Mark Allen Frank Mark I want to compare two cells. A1 contain full name , B1 contain short name . searching for formula to do a minimum match. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match similar names
On Tue, 26 Jan 2010 03:18:02 -0800, Sam wrote:
A1 B1 Frank Mark Allen Frank Mark Allen Frank Mark I want to compare two cells. A1 contain full name , B1 contain short name . searching for formula to do a minimum match. I made the following assumptions: The short name will have two and only two words If the two names in the short name exist in the same order in the long name (but not necessarily adjacent), then there is a match. =IF(ISNUMBER(FIND(LEFT(B1,FIND(" ",B1)-1),A1)+ FIND(TRIM(MID(B1,FIND(" ",B1),99)),A1,FIND( LEFT(B1,FIND(" ",B1)-1),A1))),"Match","No Match") --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match similar names
Try the below in cell C1 which will identify the last name from cell B1 and
search in A1 for a match..You can add more conditions depending on your data...For example check whether the 1st character of both cells are same.. =IF(ISNUMBER(SEARCH(TRIM(RIGHT(SUBSTITUTE(B1," ", REPT(" ",255)),255)),A1)),"Match","No match") -- Jacob "Sam" wrote: A1 B1 Frank Mark Allen Frank Mark Allen Frank Mark I want to compare two cells. A1 contain full name , B1 contain short name . searching for formula to do a minimum match. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX similar names in different rows | Excel Discussion (Misc queries) | |||
similar names - two spreadsheets | Excel Worksheet Functions | |||
Finding the MAX number while considering similar names | Excel Discussion (Misc queries) | |||
SIMILAR NAMES IN A TABLE | Excel Discussion (Misc queries) | |||
Combine query to count products with similar names | Excel Worksheet Functions |