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/enus/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