Forum Discussion
When #VALUE! isn’t an error: The hidden reference behavior of Excel’s dynamic arrays
1. Mechanism Overview Functions such as TAKE, DROP, OFFSET, and INDIRECT normally produce a range when supplied with scalar parameters. When instead a 1-D or 2-D numeric array is passed to one of th...
Combining the best of both worlds, we could simplify the beginning to:
nestedRangesϑ, MAP(TAKE(range, {1; 2; 3; 4}), THUNK)
That is an improvement!