Home > other >  Google Sheets: Return best matching text string from a column of text strings
Google Sheets: Return best matching text string from a column of text strings

Time:02-04

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)

enter image description here

  • Related