SEQUENCE

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 was added in Excel 2021.
* This function can create a Dynamic Array Formula.
* If "columns" is left blank, then 1 is used.
* If "start" is left blank, then 1 is used.
* If "step" is left blank, then 1 is used.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

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

1 - Return a sequence of numbers for an array of 1 row and 1 column.
2 - Return a sequence of numbers for an array of 1 row and 2 columns
3 - Return a sequence of numbers for an array of 2 rows and 2 columns

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