SEQUENCE
Generates a list of sequential numbers in an array
Syntax
SEQUENCE(rows, [columns], [start], [step])
Parameters
- rows: Required. The number of rows to return
- columns: Optional. The number of columns to return (default 1)
- start: Optional. The first number in the sequence (default 1)
- step: Optional. The amount to increment each subsequent value (default 1)
Example
=SEQUENCE(4, 5, 2, 3)