View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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.