fuzzy lookup for Mac
Fuzzy lookup for Mac
It would be great to have fuzzy lookup add-in for Mac.
Thanks for all your comments and votes supporting this suggestion. It would be very helpful if you would add more information about how you’d like to use fuzzy lookup in Excel.
Thanks – Steve K [MS Excel]
We would use it to match names in our company
John Henry Doe
Jon Henry Doe
J. H. Doe
John H. Doe
vs his wife that also works here
Jill Ramirez Doe
J. R. Doe
Jill R. Doe
This is just the example I am currently working on.
Note: Names have been changed protect the innocent.
Dr. K commented
Monopoly market... They don't care about their users.
[Deleted User] commented
We'd use it to match export information from our CRM system and web admin after years of poor form management. Desperately need the functionality to rationalise all our old records now I've painstakingly rebuilt the CRM and admin to match and be more compatible!
Still waiting... how hard can this really be MS? You already have the code for PC... pls extend to Mac.
Nick Leeder commented
A replication of the Windows version of the fuzzy logic plugin would be very helpful
I would use it when comparing two sets of customer lists where spelling of names and abbreviations are used inconsistently. Match Univ of Massachusetts to University of Massachusetts and to University of Mass.
I use it to compare how college majors are listed between different databases.
To the Excel Team:
Either your system has a cheesy AUTO RESPOCE to cases like this one
Or what is up with the question?
We would like to use fuzzy lookup for the exact reason it was built for!
Please take this seriously as we all pay for the software and need this for our
day to day workflow.
Anant Chaudhary commented
Dude are you ********? We will use it just like PC users use it. Did you ask this ingenius question while building up the PC version? If no, then don't ask it now. If yes, then you already have your answers. ******** product management team.
Would definitely be useful! Ive used in the past for large databases of addresses that have slight differences in spelling like NW vs Northwest or St vs Street etc... Would use it now to compare 2 lists of names for individuals from South America which tend to have several last names but not all are included in one of the two lists.
Raymond Yuan SHANG commented
+1 Please! I admire people in Window, they could use it!
Compare two or more columns and give a score for how close a match they are. Exact same functionality as the fuzzy lookup for windows
Did this ever happen?
Also to be able to set the level of "fuzziness" on a scale of 1 to 10. 10 being exact match and 1 being the loosest match
Yes, have it work exactly like the PC version where you get set the % match from 0-100% match.
Amy Wang commented
To match chemical names on different lists. Sometimes the same chemical is expressed slightly different, such as with more letters to specify structural feature or details. For instance, diarsenic pentaoxide is the same as arsenic pentaoxide.
We would use it for the very same applications of the pc version, i.e., fuzzy matching of textual data which regular formulas could not perform properly.
Looking up multiple name for the same entity to return a common looked up value.
Oksana Dovbak commented
Contact Name matches or address matches from one list to another.