SEQUENCE Function

Description

Generate a list of sequential numbers in an array.

NOTE

• The function may not work when trying to create an array that is too large.

Syntax

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

EXAMPLE 1

Copied!//𝘤𝘳𝘦𝘢𝘵𝘦 𝘢 𝘮𝘢𝘵𝘳𝘪𝘹 5𝘹1, 𝘴𝘵𝘢𝘳𝘵𝘪𝘯𝘨 𝘢𝘵 5 𝘢𝘯𝘥 𝘥𝘦𝘤𝘳𝘦𝘢𝘴𝘪𝘯𝘨 𝘣𝘺 1. 
=SEQUENCE(5, , 5, -1)
//𝘤𝘳𝘦𝘢𝘵𝘦 𝘢 𝘮𝘢𝘵𝘳𝘪𝘹 5𝘹1, 𝘴𝘵𝘢𝘳𝘵𝘪𝘯𝘨 𝘢𝘵 5 𝘢𝘯𝘥 𝘥𝘦𝘤𝘳𝘦𝘢𝘴𝘪𝘯𝘨 𝘣𝘺 1. 
=SEQUENCE(5, , 5, -1)

|    | A |
|----|---|
| 1​  | 5 |
| 2  | 4 |
| 3  | 3 |
| 4  | 2 |
| 5  | 1 |

example 2

Copied!//𝘤𝘳𝘦𝘢𝘵𝘦 𝘢 𝘮𝘢𝘵𝘳𝘪𝘹 5𝘹3, 𝘴𝘵𝘢𝘳𝘵𝘪𝘯𝘨 𝘢𝘵 5 𝘢𝘯𝘥 𝘴𝘵𝘦𝘱𝘱𝘪𝘯𝘨 𝘣𝘺 10.
=SEQUENCE(5, 3, 5, 10)
//𝘤𝘳𝘦𝘢𝘵𝘦 𝘢 𝘮𝘢𝘵𝘳𝘪𝘹 5𝘹3, 𝘴𝘵𝘢𝘳𝘵𝘪𝘯𝘨 𝘢𝘵 5 𝘢𝘯𝘥 𝘴𝘵𝘦𝘱𝘱𝘪𝘯𝘨 𝘣𝘺 10.
=SEQUENCE(5, 3, 5, 10)

|    |   A |   B |   C |
|----|-----|-----|-----|
| 1​  |   5 |  15 |  25 |
| 2  |  35 |  45 |  55 |
| 3  |  65 |  75 |  85 |
| 4  |  95 | 105 | 115 |
| 5  | 125 | 135 | 145 

EXAMPLE 3

Copied!//𝘭𝘪𝘴𝘵 𝘢𝘭𝘱𝘩𝘢𝘣𝘦𝘵𝘪𝘤𝘢𝘭 𝘤𝘩𝘢𝘳𝘢𝘤𝘵𝘦𝘳𝘴.
=CONCAT(CHAR(SEQUENCE(26, , 65, 1)))
//𝘭𝘪𝘴𝘵 𝘢𝘭𝘱𝘩𝘢𝘣𝘦𝘵𝘪𝘤𝘢𝘭 𝘤𝘩𝘢𝘳𝘢𝘤𝘵𝘦𝘳𝘴.
=CONCAT(CHAR(SEQUENCE(26, , 65, 1)))

|    |             A              |
|----|----------------------------|
| 1  | ABCDEFGHIJKLMNOPQRSTUVWXYZ |

RELATED