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