Home › Functions › Math & Trig › SEQUENCE
fx
SEQUENCE
Math & Trig  ·  Since: Microsoft 365  ·  9 languages

The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4.

🌐 Translations

English SEQUENCE
Deutsch SEQUENZ
Français SEQUENCE
Español SECUENCIA
Italiano SEQUENCE
Português SEQUÊNCIA
Nederlands VOLGORDE
Polski SEQUENCE
Русский ПОСЛЕДОВ

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

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

Arguments

rows (required) — The number of rows to return
columns (optional) — The number of columns to return
start (optional) — The first number in the sequence
step (optional) — The amount to increment each subsequent value in the array

▶ Examples

=SEQUENCE(4,5)
=SEQUENCE(5,1,1001,1000)
=SEQUENCE(5,6,INT(RAND()*100),INT(RAND()*100))

Related functions

Copied to clipboard