Uploaded May 2024 | Updated September 2026, 2 weeks ago

---

Using a combination of DROP, REDUCE, LAMBDA and VSTACK we can get the result we need.

Use this sparingly, if you try to run it on 10,000 rows it will go very slowly.

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/


Mark's blog post
exceloffthegrid.com/spill-multiple-filter-functions

Download my demo file
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiVlXav0X9hBgpGPgmxPQHwBHql15sYq9nitnqQZrR7LUg?e=xdjEr2


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


Connect with me
wyn.bio.link