Generates a list or grid of numbers with a start and step. It replaces ROW(A1:A10) tricks and feeds any function that wants a counter.

Syntax

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

Example

=SEQUENCE(12,1,1)

• A simple counter

  =SEQUENCE(5) → {1;2;3;4;5}

  One to five down a column.

• Across a row

  =SEQUENCE(1,12) → {1,2,…,12}

  One row of twelve.

• A grid

  =SEQUENCE(3,3,10,10) → {10,20,30;40,50,60;70,80,90}

  A 3 by 3 grid starting at 10 in steps of 10.

• Pairs with DATE and EDATE to build a month list in one formula.
• Dates: =SEQUENCE(7,1,DATE(2025,1,1)) gives a week of dates.
• Month-ends: =EOMONTH(start,SEQUENCE(12,1,0)).
• Pick every other row: INDEX(range,SEQUENCE(n,1,1,2)).

• #SPILL! when blocked.
• Negative steps count down; a zero step repeats the start.