Forum Discussion
Stacking The Beatles in Excel: An Exercise in 3D stacking
In an effort to turn my work into a generalized function, I'm coming to the conclusion a Lambda to stack and sort across a 3D sheet reference is not feasible.
My function checks successfully for:
- uniformity in column names in all sheets even if not in same order
- valid 3D reference
- the sheet where the function is used is not within the sheet stack
- row and column limits of Excel not exceeded by stack estimate (before dupes removed, filtering)
The main issue is Excel is incredibly shaky when stacking beyond 10,000+ rows across even 2 sheets. Stacking 10,000 elements is quick at .25 seconds. Doubling the rows leads to an immediate crash. I think this stacking could be a bit more reliable without the multiple checks but if the function will accept any 3D stack without inspection (and fail) then there are smarter options.