SEQUENCE

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

Returns the array of sequential numbers.

rows	The 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

* 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

	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