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 .
thx