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

display dynamic array results. Use SEQUENCE to Generates sequential numbers in an array. use 5 for rows, use 1 for columns, use 1 for start, use 1 for step. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SEQUENCE(5, 1, 1, 1)

Practice This Function

Practice in Sequential Mode Back to Function List