SEQUENCE
Generates a list of sequential numbers in an array, such as 1, 2, 3, 4.
Math & TrigonometryDynamic Arrays & LAMBDAMath BasicsModern Excel Functions
What it does
Generates a sequence of numbers in an array (dynamic array).
Syntax
SEQUENCE(rows, [columns], [start], [step])
Arguments
rows(number) — Number of rows to return.
Examples
Generate 5 numbers
Create numbers 1 to 5.
FORMULA
=SEQUENCE(5,1,1,1)
RESULT
[spills]
SAMPLE DATA
| A | |
|---|---|
| 1 | Rows |
| 2 | 5 |