Forum Discussion
Solved
Alternative formulas for expanding a column of row thunks.
The two options that I tried are Expandλ = LAMBDA(ϑ,
LET(
n₁, ROWS(ϑ),
n₂, MAX(MAP(ϑ,Columnsλ)),
MAKEARRAY(n₁,n₂,
LAMBDA(i₁,i₂,
INDEX(E...
Second variant is much faster. 200x90 array
Second variant gives approximately the same time on 1400x900 array
I tested on =SEQUENCE( n, m ) array and on slow PC.
First variant works on per-element basis, second one with arrays loaded into memory as one object. My guess.
Is the Excel team considering lifting this constraint in the future?
I don't think so. That means new calc engine for Excel. Build expanding into existing functions means to make it universal, i.e. workable in all possible scenarios and on different platforms. I could be wrong, but that is significant investments.