Excel Function

SEQUENCE

Generates sequential numbers in an array.

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

Arguments

rows

Required

Enter a numeric value.

columns

Optional

Enter a numeric value.

start

Optional

Enter a numeric value.

step

Optional

Enter a numeric value.

Practice Preview

Use SEQUENCE to spill a 5-row by 1-column sequence starting at 1 and increasing by 1.

Example Table

#
AProduct ID
BCategory
CProduct Name
DSales
2P001FoodApple1200
3P002FoodBanana980
4P003StationeryNotebook450
5P004StationeryPen300
6P005FoodGrapes1500
7P006StationeryRuler250
8

How to Use (Formula)

=SEQUENCE(5, 1, 1, 1)

Result

1 | 2 | 3 | 4 | 5

Practice This Function

Start Function PracticeBack to Function List

SEQUENCE FAQ

How do I use SEQUENCE in Excel?

Use SEQUENCE when you want to generate sequences automatically. Enter Rows, Columns, Start in that order, then add optional arguments when needed.

Where can I practice SEQUENCE?

Use the "Start Function Practice" button to jump straight into SEQUENCE drills.

What arguments does SEQUENCE use?

The main arguments are Rows, Columns, Start, Step. Start with the required ones, then add optional arguments if needed.