Excel Dynamic Arrays - Excel Challenge Solution

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:
https://aasolutions.sharepoint.com/:f...

Check out the videos I mentioned:

1. My Original Power Query Solution 🔥:    • Excel Expert Challenge with Wyn Hopki...  

2. The Spill Array explanation:
   • How to make an Excel Array Spill when...  

3. Autocorrect Magic
   • Faster Excel formula writing using Au...  


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
https://wyn.bio.link/