Generate numbered lists, date series, or 2D grids of numbers — with a single formula.
SEQUENCE generates an array of sequential numbers that spills automatically. No dragging, no fill handle — just one formula that creates as many numbers as you need.
SEQUENCE(rows, [columns], [start], [step])| Argument | What it means |
|---|---|
| rows required | How many rows to generate. |
| columns optional | How many columns wide. Default is 1. |
| start optional | The first number in the sequence. Default is 1. |
| step optional | How much to increase each time. Default is 1. Use negative numbers to count down. |
Generate the numbers 1 through 10 in a single column:
=SEQUENCE(10)Generate a 3-row by 4-column grid of sequential numbers starting at 100, counting by 5:
=SEQUENCE(3, 4, 100, 5)Generate every weekday in August 2026 — combine SEQUENCE with WORKDAY:
=WORKDAY(DATE(2026,7,31), SEQUENCE(23))Then format the output cells as dates. SEQUENCE generates the day-count offsets; WORKDAY converts them to real working dates.
Generate row numbers for a filtered list that always start at 1 regardless of source row position:
=SEQUENCE(COUNTA(A2:A100))=SEQUENCE(10, 1, 10, -1) generates 10, 9, 8 ... 1. Set step to any negative number to count backwards.
=CHAR(SEQUENCE(26, 1, 65)) generates A through Z using ASCII codes.Type it in a live spreadsheet, get instant feedback. No videos, no downloads.
Start practising free →