SEQUENCE function in Excel
SEQUENCE generates a list of numbers (spills).
Syntax
=SEQUENCE(rows, [columns], [start], [step])
| Argument | Required? | What it is |
|---|---|---|
| rows | Required | How many rows to fill. |
| columns | Optional | How many columns to fill (default 1). |
| start | Optional | The first number. Default 1. |
| step | Optional | How much to add each time. Default 1. |
Practise SEQUENCE in a live spreadsheet
Type the formula yourself and get it graded instantly, no Excel needed.