![]() ![]() To prepare, you’ll need your two (or three, or four!) separate data sets in separate tabs. When you’re done, head back to this post! Hopefully you’ll have a go yourself!įirstly, install the add-in by following these instructions. Really, this outcome could be achived by some simple find/replace editing but hopefully it’s enough for you to see the potential power in this process. Let’s take a look at my basic example to get you started. The add-in is remarkably powerful, especially to a user who’s only used to matching functions like VLOOKUP. You can use this add-in to cleanup difficult problems like weeding out (“fuzzy match”) duplicate rows within a single table where the duplicates *are* duplicates but don’t match exactly or to “fuzzy join” similar rows between two different tables. ![]() The Fuzzy Lookup add-in for Excel performs fuzzy matching of textual data in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |