How to make an Excel Array Spill when referencing another Array
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
https://exceloffthegrid.com/spill-mul...
Download my demo file
https://aasolutions.sharepoint.com/:f...
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/
On this page of the site you can watch the video online How to make an Excel Array Spill when referencing another Array with a duration of hours minute second in good quality, which was uploaded by the user Access Analytic 29 May 2024, share the link with friends and acquaintances, this video has already been watched 2,958 times on youtube and it was liked by 187 viewers. Enjoy your viewing!
