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 more on similar functions

Excel UNIQUE function

Excel SORT function

Excel FILTER function

Excel SORTBY function

Excel RANDARRAY function

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.