Forum Discussion
One of my offset formula does not return dynamic array but works as regular array
I was working on creating an offset function that would take its own previous value and add a few percentage growth points. It worked fine when it as a regular array (Shift + CTRL + Enter) but it did...
Hi Viz
I might handle it like this using SEQUENCE to generate the number of columns required rather than Offset
=A4*(1.05^SEQUENCE(1,10))
or making a bit more dynamic
=A4*(A3^SEQUENCE(1,B3))