Uploaded August 2024 | Updated September 2026, 2 weeks ago

---

Here I solve this challenge while introducing a number of powerful dynamic array functions

UNIQUE
XLOOKUP
SUMIFS
HSTACK
SORTBY
TAKE
DROP, REDUCE, VSTACK, LAMBDA
SEQUENCE
ROWS


📂Here's my solution file:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EjE7VTJJcU1NskzPuez3MJ0BZMzZBbps_OmmjaF-KuwCdw?e=XNrNOo

Check out the videos I mentioned:

1. My Original Power Query Solution 🔥: youtu.be/_z7N0WYLGa0?si=P40BmXTKAe5Z0Ij9

2. The Spill Array explanation:
youtu.be/REaBle3dyDM?si=ufsXUFTK0UOrMppy

3. Autocorrect Magic
youtu.be/3xK_e7HQgSE?si=YCvVBZElbUfjj9Qz


The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
wyn.bio.link