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...
lori_mI had tried experimenting with SET.NAME and DEFINE.NAME early on when I was playing with LAMBDA(x,EVALUATE(x)) for helping debug my constructions, but couldn't get it to work. I was able to get a handful of XLMs working via Name Manager, but only ones that returned info, nothing that altered the workbook. In my XLM reference I don't see a NAMES.ADD, can you reference the syntax??
