can anyone come up with a replica for the sequence function for Excel 2016?
not the type which spills over, but rather one you can use in 1 cell.
Lets say MyCustomNumber = 4
for example, instead of doing =ROWS(INDIRECT("A1:A"&MyCustomNumber)) to generate ={1;2;3;4} when evaluating [F9] in edit mode, i can use =SEQUENCE(MyCustomNumber,1) -i think that's the syntax- to generate ={1,2,3,4}.
I hope i'm clear enough
.
thx
not the type which spills over, but rather one you can use in 1 cell.
Lets say MyCustomNumber = 4
for example, instead of doing =ROWS(INDIRECT("A1:A"&MyCustomNumber)) to generate ={1;2;3;4} when evaluating [F9] in edit mode, i can use =SEQUENCE(MyCustomNumber,1) -i think that's the syntax- to generate ={1,2,3,4}.
I hope i'm clear enough
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
thx