SEQUENCE Function

Generates a list or grid of sequential numbers.

Category

Math & Trig

Available in

Microsoft 365, Excel 2021+

Returns

An array that spills

Taught hands-on in Level 4: Advanced Dynamic Arrays & Logic · Dynamic Arrays module

Overview

SEQUENCE builds a run of numbers — 1 to 10, every 5th number, a 4×3 grid — and spills it into the sheet.

Combined with dates, INDEX or TEXT it creates calendars, numbered lists and row counters that grow automatically.

Syntax

=SEQUENCE(rows, [columns], [start], [step])

Arguments

ArgumentRequired?What it does
rowsYesHow many rows to return.
columnsOptionalHow many columns. Default 1.
startOptionalThe first number. Default 1.
stepOptionalThe increase each time. Default 1 (negative counts down).

Examples

Example 1 — Numbering a list

Number five rows automatically.

A2fx=SEQUENCE(5)
A
1#
21
32
43
54
65
=SEQUENCE(5) Explain

Example 2 — Every 250 from 1,000

Price breaks starting at 1,000, going up by 250.

A2fx=SEQUENCE(1, 4, 1000, 250)
ABCD
1Price breaks
21000125015001750
=SEQUENCE(1, 4, 1000, 250) Explain

Example 3 — The next 7 days

Spill a week of dates starting today (format as dates).

=TODAY()+SEQUENCE(7)-1 Explain

Common mistakes

  • #SPILL! Cells in the way block the result. Clear them, or move the formula.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.