SEQUENCE

Dynamic arraysMicrosoft 365

Generate a spilled array of consecutive numbers.

Syntax

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

Examples

=SEQUENCE(10)

→ 1..10 down a column

=SEQUENCE(1, 12, DATE(2026,1,1), 1)

→

=EDATE(A2, SEQUENCE(1, 12, 0))

→ 12 monthly dates across

Related functions

ROW RANDARRAY MAKEARRAY

More Dynamic arrays functions

BYCOL BYROW CHOOSECOLS CHOOSEROWS DROP EXPAND FILTER GROUPBY HSTACK MAKEARRAY MAP PIVOTBY

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.