Dynamic arrays · number generation · Nov 2026

The SEQUENCE function,
measured & explained.

A measured SEQUENCE gallery: sums, grids, steps and date ranges, every value engine-verified. Live, editable, free.

D1
fx
=SEQUENCE(5, [3], [1], [1])
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How SEQUENCE works

Fills row-major (across each row, then down). Excel 365/2021+ only. Wrap in INDEX for one element, SUM for a series total, or add to DATE for a calendar.

=SEQUENCE(rows, [columns], [start], [step])
rowsRequired. How many rows to spill (>= 1).
columnsOptional. How many columns; default 1.
startOptional. First number; default 1.
stepOptional. Increment; default 1, can be negative.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Number generation

What SEQUENCE generates

SEQUENCE(rows,[columns],[start],[step]) spills a grid of numbers — the building block for test data, indices and calendars. Every result below was measured live in the engine. Click any row to load it.

Measured SEQUENCE gallery

ExpressionResultWhy
=SUM(SEQUENCE(5))15Sum of 1..5
=INDEX(SEQUENCE(5),3)3Third element of 1..5
=SUM(SEQUENCE(4,3))78Sum of a 4×3 grid (1..12)
=INDEX(SEQUENCE(3,2,10,5),1)10First element, start 10 step 5
=ROWS(SEQUENCE(7))7Spill has 7 rows
=SUM(SEQUENCE(10,1,1,2))100Sum of first 10 odd numbers
=SUM(SEQUENCE(100))5050Sum of 1..100
=INDEX(SEQUENCE(5,1,2,2),4)84th even number from 2

The four arguments, measured (static)

ExpressionResultWhy
=SEQUENCE(5)1,2,3,4,5rows only — a vertical 1-5 spill, start 1 step 1
=SEQUENCE(4,3)4×3 grid 1..12rows fill first, then columns (row-major)
=SEQUENCE(3,2,10,5)10,15 / 20,25 / 30,35start 10, step 5
=SEQUENCE(10,1,1,2)1,3,5..19odd numbers (step 2)
=SEQUENCE(5,1,2,2)2,4,6,8,10even numbers from 2
⚠ SEQUENCE is Excel 365 / 2021 only. It does not exist in 2019 or earlier and returns #NAME? there. For older Excel use ROW()/COLUMN() arithmetic: =ROW(A1) filled down, or =(ROW(A1)-1)*3+COLUMN(A1) for a grid.
Compose it: INDEX(SEQUENCE(5),3)=3 grabs one element; SUM(SEQUENCE(100))=5050 totals a series; DATE(2026,1,1)+SEQUENCE(30) spills 30 consecutive days. SEQUENCE + TRANSPOSE builds outer products.
// 03 — Try it live

Interactive SEQUENCE playground

Edit the Sales column; SUM-based presets update. SEQUENCE generates from its arguments, independent of the grid.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where SEQUENCE works

SEQUENCE is Excel 365/2021+ only; older Excel returns #NAME?. Google Sheets and Excel for the web support it.

PlatformSupportNotesGotcha
✓ Supported full SEQUENCE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master dynamic arrays

SEQUENCE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • SEQUENCE — generate numbers, indices, calendars
  • rows / columns / start / step
  • Row-major fill and TRANSPOSE
  • Outer products with SEQUENCE * TRANSPOSE(SEQUENCE)
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked