Perform Fuzzy Lookups in Excel

No video

Perform Fuzzy Lookups in Excel

Рет қаралды 138,041

Күн бұрын

This is a solid Excel tip that will help you clean up your data in minutes. Use an Excel Add-In to easily perform approximate string matching (i.e. Fuzzy Look-ups).
Download tool here: www.microsoft....
Join this channel to get access to perks:
/ @anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/antho...
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoff...
★☆★ Support this Channel: ★☆★
👕 Merch ► shop.spreadshirt.com/AnthonySmoak

Пікірлер: 80

@MixXD947 Жыл бұрын

Thanks for simple yet detail explanation

@AnthonySmoak Жыл бұрын

Thanks for the comment!

@mpqz1212 3 жыл бұрын

You're a life-saver!

@MrLinkolin 3 жыл бұрын

This video is immensely helpful, thanks so much for putting it out there!

@AnthonySmoak 3 жыл бұрын

Thanks for the kind words!

@analytics3662 2 жыл бұрын

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!

@yashdeep2277 3 ай бұрын

This was so easy. Thanks a bunch.

@AnthonySmoak 2 ай бұрын

Glad to hear it, thank you!

@mihirachandrasiri9307 16 күн бұрын

Thank you vey much!

@AnthonySmoak 16 күн бұрын

Thanks for the comment!

@lazycleaning9987 9 ай бұрын

Man you saved me a lot of time. Thanks a ton

@AnthonySmoak 4 ай бұрын

Glad to hear the video helped!

@simple.boy0 3 жыл бұрын

This is what I'm looking for! Thank you for sharing this!

@AnthonySmoak 3 жыл бұрын

Glad it was helpful!

@Blobbert_8 2 жыл бұрын

Thank you so much! Exactly what I was looking for and never heard of fuzzy look up till now

@RonaldDraxer-rb4qm Ай бұрын

Most of the companies wont allow to use add ins. You can use power query approximate matching as a life saver for this

@erinharrington752 5 жыл бұрын

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.

@excelworx8712 4 жыл бұрын

that's new to me - the add in. i use fuzzy lookups in powerquery, but didnt know about an addin. will try soon

@thehartkrusher 2 жыл бұрын

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!

@AnthonySmoak 2 жыл бұрын

Thanks for leaving a like and comment. Glad my video helped save you some time and effort. Work smart not hard whenever you can!

@TheMrRomely 2 жыл бұрын

Easier explanation ever. thank you

@AnthonySmoak 2 жыл бұрын

Thank you!

@OnlineGurukull Жыл бұрын

Extremely helpful, Saved the day. Than You ;)

@popi20101 5 жыл бұрын

Thank you very much for your explanation. I've never tried before but I've ever heard about that

@mikecroak6044 4 жыл бұрын

Nice Explanation and Example

@andressolano3466 4 жыл бұрын

Well done, Anthony! Great tip.

@AnthonySmoak 4 жыл бұрын

Thank you Andres!

@png8592 3 жыл бұрын

Thanks for the tutorial!

@AnthonySmoak 3 жыл бұрын

Glad you enjoyed it!

@anikar1302 3 жыл бұрын

You're awesome!!! You made it so easy for me. thanks mate

@jl8217 3 жыл бұрын

Thank you, this is a great explanation, straight to the point

@crazyme123ify Жыл бұрын

Thanks dude! super helpful

@AnthonySmoak Жыл бұрын

Glad to hear it dude!

@divyanivalkar7877 Жыл бұрын

Thank you so much it will help a lot.

@AnthonySmoak Жыл бұрын

Glad to hear it. Thanks for the comment.

@malikaouenza945 4 жыл бұрын

Great explanation Thank you

@fredrickmuge7538 2 жыл бұрын

Super fantastic!!! thanks a lot

@AnthonySmoak 2 жыл бұрын

Thanks for the comment!

@Pixiesvin 5 жыл бұрын

Thank you! Just what I needed :)

@AnthonySmoak 5 жыл бұрын

Great, glad it helped!

@carrerr23 3 жыл бұрын

This is amazing. It helped me a lot. Thank you 😊

@AnthonySmoak 3 жыл бұрын

Wonderful, glad to hear it!

@caoimhecarton7556 4 жыл бұрын

Thank you!! This was so helpful!!

@yarramkartheekreddy9163 9 ай бұрын

Great video 💯❤

@AnthonySmoak 9 ай бұрын

Thank you sir!

@gersonsalcedo3227 5 жыл бұрын

Thanks man, really useful!

@sepidehberangi5768 4 жыл бұрын

I couldn't thank you enough!

@AnthonySmoak 4 жыл бұрын

These are my favorite types of comments! Thanks!

@niamhmongey6933 4 жыл бұрын

Fantastic - thanks so much!

@renetatuacastillo19 4 жыл бұрын

Could you please check my fuzzy matching software matchkraft.com/? I did it, and i think it is better than excel jhahah.

@i_epioneer2965 6 жыл бұрын

thank u for link and great explaining.

@abhishekbansal8629 8 ай бұрын

Great!

@AnthonySmoak 8 ай бұрын

Thanks!

@pulseofdinesh8091 3 жыл бұрын

Amaing one mate

@AnthonySmoak 3 жыл бұрын

Thank you!

@saurabhburman4378 7 ай бұрын

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.

@aniketbarve887 3 жыл бұрын

that was too good

@AnthonySmoak 3 жыл бұрын

Thank you!

@danrussell8572 6 жыл бұрын

Excellent explanation, thanks

@AnthonySmoak 6 жыл бұрын

Thanks! Glad you found it useful Dan.

@sadiatalukder4007 3 жыл бұрын

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

@windtalkerer8554 4 жыл бұрын

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.

@MrBuihongmanh 4 жыл бұрын

thank you for sharing

@strngf7 2 жыл бұрын

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?

@AbhishekShuklaAbK 4 жыл бұрын

Wow!

@AnthonySmoak 4 жыл бұрын

Hopefully a good wow!

@AbhishekShuklaAbK 4 жыл бұрын

@@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, KZfaq, YoTube, etc. So is it possible to find similarities within only one column?

@AnthonySmoak 4 жыл бұрын

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.

@georgejoseph7519 Жыл бұрын

Hi Anthony can you provide us with this table ?

@muhammadnasiralimalik1288 2 ай бұрын

How we bring address in result tab plz plz guide me.

@mtstans 2 жыл бұрын

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 2 жыл бұрын

Sorry I don't quite understand, you're trying to fuzzy match binary data (1s and 0s) to other binary data using Excel?

@mtstans 2 жыл бұрын

@@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.

@ubaidillahmuhammad20 4 жыл бұрын

loved. May I have the excel file ?

@AnthonySmoak 4 жыл бұрын

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.

@novianggriani3122 6 жыл бұрын

i had download fuzzy looks ups but i can't run that application, can you help me?

@harrisandrews8741 5 жыл бұрын

Did you check the system requirements on the add-in download page? This add-in only works on the windows version of Excel.

@SullivanSoftware 4 жыл бұрын

If Excel won't work for you, try www.mpods.app/cgi-bin/fuzzy-lookup

@mgee9543 6 ай бұрын

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.

@AnthonySmoak 6 ай бұрын

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.