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 and was released in July 2020.
* 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 }

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