Home/Formulas/Array/SEQUENCE
Arraymedium

SEQUENCE()

Generates a sequence of numbers, returned as an array of the requested shape.

Syntax
fx
=SEQUENCE(rows, [columns], [start], [step])
Arguments
ArgumentDescription
rowsThe number of rows.
[columns]The number of columns. Defaults to 1.
[start]The starting value. Defaults to 1.
[step]The step between values. Defaults to 1.
Example
fx
=SEQUENCE(5)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and SEQUENCE isn't one of them yet.

Related formulas
ARRAYFORMULA()
Enables the display of values returned from an array formula into multiple rows/columns.
FILTER()
Returns a filtered version of the source range, returning only rows or columns which meet the conditions.
SORT()
Sorts the rows of a range by values in one or more columns.
More Array formulas →Keyboard shortcuts for Sheets →