Finding the closest string match

Question

in relation to the post below:https://techcommunity.microsoft.com/t5/Excel/quot-Close-enough-quot-MATCH/m-p/286868#M21384I would like to know the formula to find the closest string match (instead of numbers)many thanks..&nbsp;

sergeibaklan · Answer

Hi Lorenzo,
&nbsp;
For that we shall to define first the rule which strings to consider as close. Fuzzy logic is not available in Excel out of the box. In Power BI Desktop Fuzzy Matching was introduced recently as preview, hope one day will be in Excel as well. One option is to use third-party tools like&nbsp;http://officepowerups.com/help-support/excel-function-reference/excel-text-analyzer/pwrsimilarity/ our generate the rules ourselves.

lorenzo kim · Answer

thank you very much for your reply and valuable info..

Forum Discussion

Finding the closest string match

Share

Resources