Power Query Fuzzy Matching (Automated reconciliation)

Create an automated reconciliation statement using Excel Power Query's Fuzzy Match. This is used when there are differences in spelling.

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) - https://www.microsoft.com/en-us/downl...

👉 Join now our QnA Community - https://bit.ly/335Fic7

Techniques used:
Excel's Power Query Editor (Transform Data)
Fuzzy Match (Threshold or Tolerance, Ignore Case)
Full Outer Join

Download Practice files - https://bit.ly/3sf2sHi

How to Reconcile Names of Different Spellings in Excel
   • Fuzzy Lookup | How to Reconcile Names...  

Let's Connect:

👉 Follow us on Instagram   / yodalearning  
👉 Follow our boards at   / pins