Parameter List
Syntax
SEQUENCE(rows,
[columns]
, [start]
, [step]
)rows
The number of rows to fill with the sequence. For example: 5
to create 5 rows.
[optional] columns
The number of columns to fill with the sequence. For example: 3
to create 3 columns. If omitted, defaults to 1
.
[optional] start
The first number in the sequence. For example: 10
to start the sequence at 10. If omitted, defaults to 1
.
[optional] step
The amount to increment each subsequent value in the sequence. For example: 5
to increase each value by 5. If omitted, defaults to 1
.
More details
SEQUENCE() returns an array of sequential numbers directly to the worksheet or as part of an array formula. This makes it useful for quickly generating sequential data, creating sample data sets, or as input to other array functions.