All functions / Dynamic arrays
SEQUENCE
Generates a list of sequential numbers that spills into neighbouring cells.
Syntax
=SEQUENCE(rows, [columns], [start], [step])
Arguments
rows: How many rows.columns(optional): How many columns (default 1).start(optional): First number (default 1).step(optional): Increment (default 1).
Example
=SEQUENCE(5) → 1, 2, 3, 4, 5 down a column