Finding the closest string match

Hi Lorenzo,

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 http://officepowerups.com/help-support/excel-function-reference/excel-text-analyzer/pwrsimilarity/ our generate the rules ourselves.