Let's say we have the name "Giorge", I'm looking for a way to return the best matching name from the table of names below:
Names |
---|
George |
Patrick |
Charles |
CodePudding user response:
try:
=SORTN(A2:A4, 1, 1, LEN(REGEXREPLACE(A2:A4, "["&B2&"]", )), 1)