In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how it is done.
- How to link files and change the file
- Reflecting on 2022 – Failures & Disappointments, what went well and lessons learned.
- How to check for duplicates across worksheets – using Power Query Append
- How to use removed unwanted spaces with Power Query – AKA Trim
- What I learned from the 2022 Tour de France