SEQUENCE Function

Sequence Function

About

The Excel SEQUENCE function is a DYNAMIC ARRAY FUNCTION that can generate a list or array of sequential numbers. The array can be one dimensional or two-dimensional.

Function Type

Math and trigonometry

Purpose

Generate an array of sequential numbers

Return value

An array of sequential numbers

Syntax

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

Arguments

rows – number of rows of the array

columns – [optional] Number of columns of array

start – [optional] starting value. Default value is 1

step – [optional] Increment between each value. Default value is 1


Examples

Example 1

Use the formula to create a sequence of numbers from 1 to 10

=SEQUENCE(10)

Example 2

To create an array of size 10 x 10 containing a sequence of numbers from 1 to 100 use the following formula

=SEQUENCE(10,10)

Example 3

Formula to create an array of size 5 x 7 containing a sequence of numbers starting from 253

=SEQUENCE(5,7,253)

Example 4

Formula to create an array of size 8 x 8 containing a sequence of numbers having a difference of 3, starting from 1500.

=SEQUENCE(8,8,1500,3)

Example 5

The SEQUENCE function can also handle negative numbers and decimals.

Formula to create an array of size 10 x 10 containing a sequence of numbers having a difference of 2.5, starting from -7.8.

=SEQUENCE(10,10,-225.3,2.5)

Notes

The FILTER function returns an array of values and these values ‘spill’ into the spill range on the worksheet. If this spill range contains any data, the function will return a #SPILL! error.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel