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.
|