Power Query Fuzzy Matching (Automated reconciliation)

[@preethiagarwal5355]

Presentation skill is fantastic...

[@jemo1108]

Thanks a lot for this. It has saved me a lot of time

[@dharmpatel6067]

THANKS FOR SHARING THIS TECHNIQUE...

[@chaitanyasunny5872]

Thanks you so much....your great explaining....you made me hero

[@hemantjoshi5034]

Thanks for explaining in such a simple way. Is it possible to have reconciliation done with invoice number on both tables after matching out the vendor / customer ? ,Also, matching the amount showing any variance in amounts for an invoice number of vendor. If yes do explain. Again, many thanks !

[@SanviPatil2019]

superb rishabh sir... amazing

[@patelimran664]

Thank you for sharing such a very helpful information.....👍🏻

[@ca.rajeevthakur9574]

Excellent
Excellent

[@janardhanreddy9836]

Thank you a lots it's going to be more helpful.

[@velocitypta]

Great video sir

[@ansarymariama2467]

Do you sell couses in vidéo?

[@leomason15]

Thank you!

[@NjaanAdima]

excellent

[@FoolishBubbles]

Excellent video! Is there a way do use fuzzy matching to find fuzzy matches in one data set? Like two names spelt differently in the same table

[@marynabatova4867]

I just Added the needed Table to Power Query.. and then duplicated the table on the right hand navi , then compared the same column against itself actually.. it seems to work

[@user-tn5zo1mx9n]

fantastic

[@strngf7]

This is for Excel 2010. The option for fuzzy match under join kind is not showing. Any ideas why?

[@adrishasaha1573]

I am using 2019 version of excel. When i entered into merge query threshold level is not showing. Pls advise what to do next

[@mamalik1088]

Nice

[@shahinakhatoon2114]

Sir ...please tell me how to make merit list according to marks and date of birth...

[@shahinakhatoon2114]

If candidates have same marks then how to prepare merit list according to date of birth

[@nth.education]

Will this also work with 500,000+ rows data sets ? Or should we use R/Python for those ?

[@janardhanreddy9836]

But there's no fuzzy lookup object in 2016 version pls guide where can I get option

[@Yodalearning]

Important Note:
This is only in Office 365. If you have the perpetual licensed version of Excel 2016, you won't get it. It isn't even in Excel 2019. It will likely exist in Excel 2022 (or whenever they launch another perpetual license version), or you can get today with Office 365. For now, you can practice by downloading Microsoft Power BI Desktop (free) - www.microsoft.com/en-us/download/details.aspx?id=58494

[@marctemura2017]

👍⭐

[@ansarymariama2467]

www ❤❤❤❤

[@gopalkumargupta1985]

Sir how I contact you. I need your help

[@01716392471]

Excellent .. just love it

[@smitashevade3746]

I am sending mail and also doing whatsapp to change my email id.
My name is Smita Shevade and I joined in Oct 20.