I need a search formula

[33sameer33]

Hi,

I have a long list of GSM numbers and the client is looking for a GSM number similar to a specific number .How can I make a search formula that able to give me a list of similar GSM numbers based on certain criteria.

example. 773466623

similar GSM 772366623 or 773455523-or 772299915

 

[vletm]

33sameer33
How similar those numbers should be?
Should there be all numbers or at least one same number?

 

[GraH - Guido]

Hi,
VBA code is available for Levenshtein distance and distance%.
If you have Power Query in Excel, you can play with fuzzy match.

 

[Peter Bartholomew]

Hi @GraH - Guido
I have seen several mentions by you of the Levenshtein distance between strings. The attached file contains my attempt to get to grips with it as an Excel Lambda function.

 

[GraH - Guido]

Amazing @Peter Bartholomew!