SEQUENCE function

The SEQUENCE function returns an array of sequential numbers, such as 1, 2, 3, 4.

Parts of a SEQUENCE function

SEQUENCE(rows, columns, start, step)

Part Description
rows Required. The number of rows to return
columns Optional. The number of columns to return. If omitted, the returned array will have one column.
start Optional. The number to start the sequence at. If omitted, the sequence will start at 1.
step Optional. The amount to increase/decrease each number in the sequence. If omitted, the sequence will increase by 1.

Sample formulas

Example 1: SEQUENCE(2)

Example 2: SEQUENCE(2, 3)

Example 3: SEQUENCE(2, 3, 3, 2)

Example 4: SEQUENCE(2, 3, 10, -1)

Notes

If columns is omitted, the resulting array will be a vertical list. If a horizontal list is needed, either specify rows as 1 and specify columns or transpose the vertical result.

Result for A1=SEQUENCE(2)

  A B
1 1  
2 2  

Result for A1= SEQUENCE(2, 3)

  A B C
1 1 2 3
2 4 5 6
3      

Result for A1= SEQUENCE(2, 3, 3, 2)

  A B C
1 3 5 7
2 9 11 13
3      

Result for A1= SEQUENCE(2, 3, 10, -1)

  A B C
1 10 9 8
2 7 6 5
3 4 3 2

Related functions

  • MUNIT: The MUNIT function returns a unit matrix of size dimension x dimension.
  • RANDARRAY: The RANDARRAY function generates an array of random numbers between 0 and 1.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
11326925786653777495
true
Search Help Center
true
true
true
true
true
35