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.