Fuzzy Lookup Excel For Mac

I have found EXACTLY what I am looking for, but alas it is only for Windows versions of Excel (of course). Here is what I need: I have a spreadsheet with names (split into two cells, first and last) and addresses. If the names and addresses are an approximate match, I need something to happen (highlight, delete duplicates, etc. I can do that code myself most likely). The tricky part is addresses.

The Fuzzy Lookup Add-In for Microsoft Excel. Fuzzy Lookup Add-In can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables. The matching is robust to a wide variety of errors including spelling mistakes, abbreviations, synonyms and added/missing data. For instance. Nov 06, 2014  The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel. The Fuzzy Lookup Add-In for Excel was developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel. It can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables.

Free house plan drawing software for mac. I want 1234 E. Broadway Street to match 1234 East Broadway St. I cannot use left, right, or mid functions because the variable characters aren't always in the same position. The 'Fuzzy Lookup For Excel Add-In' seems to be what I need, but I can't test it for sure. Is there a way to do a sort of fuzzy lookup already built into Excel?

Or a macro I can copy-paste to use (I'm not familiar with them, but I know they exist and maybe it's time I learn how). Any help, suggestions, etc. Are much appreciated.