# SEQUENCE Function

Table of Contents

### 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