SEQUENCE
Generates a list of numbers.
How it’s written
SEQUENCE(rows, columns, start, step)Example
| A | |
|---|---|
| 1 | Count |
| 2 | 4 |
=SUM(SEQUENCE(A2))Result: 10
Generates 1, 2, 3 and 4, then adds them.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Quick for numbering rows or building test data.
Practice it properly
UNIQUE and SORT gives you real tasks, with your formulas tested on data you haven’t seen.