Forum Discussion
A statement of truth or a wasted opportunity. Lambda helper functions reluctant to return 2D arrays.
I remember JoeMcDaid stating that 2D arrays are the only data types held in Excel; rows columns and scalars are merely special cases with the last being a 1x1 array. So why is it such a proble...
That's cool that works. In a recent blog post, it sounded like XLM is going to be turned off by default for security reasons. I wonder if one can use CHOOSE({1;2;3},...) with multiple LAMBDAs as well?
I played around some more and discovered one can also add names via data validation! This removes the need for creating functions with side effects and also works with undo. I've attached another example which I think could be workable.
I think lightning struck us at the same time regarding CHOOSE from looking at the timestamps. Just had to put a workbook together!