SEQUENCE(rows [,columns] [,start] [,step])

Returns the array of sequential numbers.

rowsThe number of rows to return.
columns(Optional) The number of columns to return.
start(Optional) The first number in the sequence.
step(Optional) The amount to increment each subsequent value in the array.

Remarks

* This function is only available in Microsoft 365.
* This function can return a Dynamic Array Formula.
* For the Microsoft documentation refer to support.office.com

 A
1=SEQUENCE(1) = 1
2=SEQUENCE(1,2) = { 1, 2 }
3=SEQUENCE(2,2) = { 1, 2; 3, 4 }

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top