View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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.