Forum Discussion

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 07, 2022
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...
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    May 08, 2022

    PeterBartholomew1 

    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.

Patrick2788's avatar
Patrick2788
Silver Contributor
May 09, 2022
I've only read through page 1 of that thread but must say your ideal for GLOBAL is exciting. I hope someone was taking notes.
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 10, 2022

Patrick2788 

I think back in the day of the XLM macro language quite complicated definitions could be made on macro sheets.  My thought here was that, since formula scoped names can now be defined using LET, why not extend that to sheet or global names?

 

To work on the definition one would select the cell, which would automatically load the formula into the AFE (just as it does now with the formula bar).  Once edited, it would be back visible on the sheet rather than being hidden away behind defined Names interface.  I wouldn't like to guarantee that all users even know that the Name 'environment' even exists, so to have critical parts of the calculation hidden away in a as 'code' is not ideal.

Resources