thank you for sharing this wonderful tip for matching multiple words or how to match more then 1 words in excel apart from Vlookup with Wildcard or Xlookup or Search or index formula. This method is more helpful in controlling the accuracy with percentage match. THANK YOU SO MUCH!
Great video , i was about to write a python script to do this when i stumbled upon your video. Never would've found out about the add in otherwise. Thanks a bunch!
Thank you so much! I had never heard of a FVL before today, and I was left to my own devices on a new report. I'm happy to say that it only took me an hour, LOL.
Thanks for the vid! The add-in's not very self-explanatory when you first open it. I was looking for a way to compare a list of current clients with a WIP prospect list.
Hi Anthony. This is really helpful. Is there a way I can save the config. I have similar data coming everyday and need to perform the same logic. Everytime I have to establish the connection. Change the similarity threshold. Can we permanently fix it. Is there a way? Your help will be highly appreciated.
Can one set the fuzzy lookup to search for variation in last two characters? My code varies is last two characters and I don't know how to separate it. Any help would be appreciated. Thanks in advance.
this is just what I needed! but it doesn't seem to work with numbers. I formatted both columns as text (they arent really numbers but numerical codes so they should be put as text ) but when i tried to find the similarity, it would give me 0 if its not an exact match. And it would also convert one column back into numbers and i dont know why. i feel like crying. im an intern and i feel like im not proving myself
Good video. Just found this tonight. Any tips on matching multiple columns? I have a table with 16 rows and 30 columns of binary data that I want to match with another set of data with the same columns (and binary data) and a crap ton of other rows. What I'm trying to do is to use it to categorize what my new data set should belong to. Having probs also as it runs one time ok, but when I want to make change and re run it, it seems to crash. Any tips? thanks.
@@AnthonySmoak yes but it's not working out. New to all this data stuff and just trying different things as discover topics to see how I can play with my data. After playing around with it tonight, I don't think this add on is intended for this use.
The right columns with more than 1 columns are not showing for some reason, it is showing the column names from the left table, even through the right table showing the correct table. What could be causing this?
@@AnthonySmoak Yes, a good one! I have one question if you don't mind answering. How can we do this in only 1 list of names? For example - I have a list of names like - Apple, Appl, Google, Googl, RUclips, YoTube, etc. So is it possible to find similarities within only one column?
I don't believe there is an easy method to accomplish this in Excel. There is a Fuzzy Grouping transformation in SSIS for use with SQL Server you can investigate.
Thanks - what a terrible add-in - I'd have optipns for cleanup (,.& and spaces) then remove common words like PLC then reduce long words like university - and then trim down - and then use fuzzy logic - Sorry but this is appaling.
Excel is a useful swiss army knife. There are better specialized, individual tools to meet a need, but you get a little bit of everything packaged in Excel. Power Query would be a better tool if you're looking for transformations and the use of fuzzy matching. Python is probably best, if you have the time and knowledge.
Thanks for simple yet detail explanation
Thanks for the comment!
thank you for sharing this wonderful tip for matching multiple words or how to match more then 1 words in excel apart from Vlookup with Wildcard or Xlookup or Search or index formula. This method is more helpful in controlling the accuracy with percentage match. THANK YOU SO MUCH!
This video is immensely helpful, thanks so much for putting it out there!
Thanks for the kind words!
that's new to me - the add in. i use fuzzy lookups in powerquery, but didnt know about an addin. will try soon
You're a life-saver!
This is what I'm looking for! Thank you for sharing this!
Glad it was helpful!
Man you saved me a lot of time. Thanks a ton
Glad to hear the video helped!
Great explanation thanks for the help!
@@adieingale8547 Thank you!
Great video , i was about to write a python script to do this when i stumbled upon your video. Never would've found out about the add in otherwise.
Thanks a bunch!
Thanks for leaving a like and comment. Glad my video helped save you some time and effort. Work smart not hard whenever you can!
This was so easy. Thanks a bunch.
Glad to hear it, thank you!
Thank you so much! I had never heard of a FVL before today, and I was left to my own devices on a new report. I'm happy to say that it only took me an hour, LOL.
Thank you so much! Exactly what I was looking for and never heard of fuzzy look up till now
Most of the companies wont allow to use add ins. You can use power query approximate matching as a life saver for this
Thank you very much for your explanation. I've never tried before but I've ever heard about that
Easier explanation ever. thank you
Thank you!
Extremely helpful, Saved the day. Than You ;)
Nice Explanation and Example
Thanks for the vid! The add-in's not very self-explanatory when you first open it. I was looking for a way to compare a list of current clients with a WIP prospect list.
You are right, it is not intuitive at all. Glad my video helped clear up some confusion. Thanks for the comment!
Thank you vey much!
Thanks for the comment!
You're awesome!!! You made it so easy for me. thanks mate
Thank you, this is a great explanation, straight to the point
Thanks for the tutorial!
Glad you enjoyed it!
Thanks dude! super helpful
Glad to hear it dude!
Hi Anthony. This is really helpful. Is there a way I can save the config. I have similar data coming everyday and need to perform the same logic. Everytime I have to establish the connection. Change the similarity threshold. Can we permanently fix it. Is there a way? Your help will be highly appreciated.
Thank you so much it will help a lot.
Glad to hear it. Thanks for the comment.
Well done, Anthony! Great tip.
Thank you Andres!
Super fantastic!!! thanks a lot
Thanks for the comment!
Great video 💯❤
Thank you sir!
Great explanation Thank you
Can one set the fuzzy lookup to search for variation in last two characters? My code varies is last two characters and I don't know how to separate it. Any help would be appreciated. Thanks in advance.
This is amazing. It helped me a lot. Thank you 😊
Wonderful, glad to hear it!
Thank you!! This was so helpful!!
Thank you! Just what I needed :)
Great, glad it helped!
thank u for link and great explaining.
Fantastic - thanks so much!
Could you please check my fuzzy matching software matchkraft.com/? I did it, and i think it is better than excel jhahah.
I couldn't thank you enough!
These are my favorite types of comments! Thanks!
Thanks man, really useful!
Amaing one mate
Thank you!
Great!
Thanks!
Hi Anthony can you provide us with this table ?
this is just what I needed! but it doesn't seem to work with numbers. I formatted both columns as text (they arent really numbers but numerical codes so they should be put as text ) but when i tried to find the similarity, it would give me 0 if its not an exact match. And it would also convert one column back into numbers and i dont know why. i feel like crying. im an intern and i feel like im not proving myself
Good video. Just found this tonight. Any tips on matching multiple columns? I have a table with 16 rows and 30 columns of binary data that I want to match with another set of data with the same columns (and binary data) and a crap ton of other rows. What I'm trying to do is to use it to categorize what my new data set should belong to. Having probs also as it runs one time ok, but when I want to make change and re run it, it seems to crash. Any tips? thanks.
Sorry I don't quite understand, you're trying to fuzzy match binary data (1s and 0s) to other binary data using Excel?
@@AnthonySmoak yes but it's not working out. New to all this data stuff and just trying different things as discover topics to see how I can play with my data. After playing around with it tonight, I don't think this add on is intended for this use.
The right columns with more than 1 columns are not showing for some reason, it is showing the column names from the left table, even through the right table showing the correct table. What could be causing this?
How we bring address in result tab plz plz guide me.
thank you for sharing
that was too good
Thank you!
Excellent explanation, thanks
Thanks! Glad you found it useful Dan.
loved. May I have the excel file ?
I don't have it anymore. This video was from 3 years ago! Its easy enough to generate mock data from the Fortune 500 list.
Wow!
Hopefully a good wow!
@@AnthonySmoak Yes, a good one! I have one question if you don't mind answering. How can we do this in only 1 list of names? For example - I have a list of names like - Apple, Appl, Google, Googl, RUclips, YoTube, etc. So is it possible to find similarities within only one column?
I don't believe there is an easy method to accomplish this in Excel. There is a Fuzzy Grouping transformation in SSIS for use with SQL Server you can investigate.
i had download fuzzy looks ups but i can't run that application, can you help me?
Did you check the system requirements on the add-in download page? This add-in only works on the windows version of Excel.
If Excel won't work for you, try www.mpods.app/cgi-bin/fuzzy-lookup
Thanks - what a terrible add-in - I'd have optipns for cleanup (,.& and spaces) then remove common words like PLC then reduce long words like university - and then trim down - and then use fuzzy logic - Sorry but this is appaling.
Excel is a useful swiss army knife. There are better specialized, individual tools to meet a need, but you get a little bit of everything packaged in Excel. Power Query would be a better tool if you're looking for transformations and the use of fuzzy matching. Python is probably best, if you have the time and knowledge.