pinarello
Member
- Joined
- Jun 21, 2019
- Messages
- 218
- Reaction score
- 4
- Points
- 18
- Location
- Germany
- Excel Version(s)
- Office 365
Since I haven't come across a free fuzzy search yet, it is of course easy to use the adjective "best". But of course I'm also pursuing the goal that one or the other thinks to himself: "if he already takes his mouth so full, then I'll test it a bit more closely and mercilessly denounce everything that doesn't meet the expectations". This is exactly my goal, because a lot of constructive critics increases the chance to improve something.
With the fuzzy search presented here, it is possible to search from a stock of about 4,500 or 25,000 addresses without having to know the exact spelling of the names, places and streets. To do this, the addresses are encoded once according to the defined fuzzy rules, and then searched using the search terms, which are also encoded. The complete addresses are then displayed for the hits. Further information can be found in the uploaded documentation.
The files:
Fuzzy search.docx - Documentation with many further information.
Addresses 4500.xlsb - This workbook contains about 4.500 addresses. Download > save.
Replacements.xlsx - This folder contains all replacements and synonym mappings. Download > save
Fuzzy search prepare addresses.xlsm - Download > save > Allow macro execution > In the worksheet "Params" adjust settings for "Directory" and "File" > In the worksheet "Data prepared" press the button "Prepare Data" after any changes in the addresses.
Alternatively save the file as .xlsx (no macros) > make sure that the macros in the docs are harmless > insert macro "prepare_data" into the workbook > assign the macro to the button > press button "Prepare Data" > save workbook as .xlsm
Fuzzy search - EN.xlsm - Download file > Allow macro execution > Adjust settings for "Directory" and "File" in the worksheet "Params
Alternatively use the macros from the documentation.
Hint: Because when opening the workbook automatically queries run, with which the replacements, addresses as well as the formatting search data are imported, these run at the first opening on an error, since in the worksheet "Params" the assignments are not yet adjusted.
Now I just hope that the application runs as smoothly on all interested as it does on my PC. Otherwise simply report, so that we get the cow of the ice, which should not be particularly thick with the current temperatures then.
Here is the link to the worrkbook with 25,000 addresses: https://1drv.ms/x/s!AjraeoAbqhhvgbZUrMVOuCX57gzR4g
With the fuzzy search presented here, it is possible to search from a stock of about 4,500 or 25,000 addresses without having to know the exact spelling of the names, places and streets. To do this, the addresses are encoded once according to the defined fuzzy rules, and then searched using the search terms, which are also encoded. The complete addresses are then displayed for the hits. Further information can be found in the uploaded documentation.
The files:
Fuzzy search.docx - Documentation with many further information.
Addresses 4500.xlsb - This workbook contains about 4.500 addresses. Download > save.
Replacements.xlsx - This folder contains all replacements and synonym mappings. Download > save
Fuzzy search prepare addresses.xlsm - Download > save > Allow macro execution > In the worksheet "Params" adjust settings for "Directory" and "File" > In the worksheet "Data prepared" press the button "Prepare Data" after any changes in the addresses.
Alternatively save the file as .xlsx (no macros) > make sure that the macros in the docs are harmless > insert macro "prepare_data" into the workbook > assign the macro to the button > press button "Prepare Data" > save workbook as .xlsm
Fuzzy search - EN.xlsm - Download file > Allow macro execution > Adjust settings for "Directory" and "File" in the worksheet "Params
Alternatively use the macros from the documentation.
Hint: Because when opening the workbook automatically queries run, with which the replacements, addresses as well as the formatting search data are imported, these run at the first opening on an error, since in the worksheet "Params" the assignments are not yet adjusted.
Now I just hope that the application runs as smoothly on all interested as it does on my PC. Otherwise simply report, so that we get the cow of the ice, which should not be particularly thick with the current temperatures then.
Here is the link to the worrkbook with 25,000 addresses: https://1drv.ms/x/s!AjraeoAbqhhvgbZUrMVOuCX57gzR4g