Google Sheets: How to Use SEQUENCE Function


You can use the SEQUENCE function in Google Sheets to return an array of sequential numbers.

This function uses the following basic syntax:

SEQUENCE(rows, columns, start, step)

where:

  • rows: The number of rows to return
  • columns: The number of columns to return (default is 1)
  • start: The number to start the sequence at (default is 1)
  • step: The amount to increase or decrease each number in the sequence (default is 1)

The following examples show to use this function in different scenarios in Google Sheets.

Example 1: Create Sequence of Values in One Column

We can use the following formula to create a sequence of values in one column:

SEQUENCE(10)

The following screenshot shows how to use this formula in practice:

The result is a single column that contains the sequential values 1 through 10.

Example 2: Create Sequence of Values in One Row

We can use the following formula to create a sequence of values in one row:

SEQUENCE(1, 5)

The following screenshot shows how to use this formula in practice:

The result is a single row that contains the sequential values 1 through 5.

Example 3: Create Matrix of Sequential Values

We can use the following formula to create a matrix of values with 10 rows, 3 columns, starts at 0, and increases each value by 5:

SEQUENCE(10, 3, 0, 5)

The following screenshot shows how to use this formula in practice:

Google Sheets sequence function

The result is a matrix with 10 rows, 3 columns, starts at 0, and increases each value by 5.

Note: You can find the complete documentation for the SEQUENCE function in Google Sheets here.

Additional Resources

The following tutorials explain how to use other common functions in Google Sheets:

How to Use AVERAGEIFS Function in Google Sheets
How to Use ISERROR Function in Google Sheets
How to Ignore #N/A Values with Formulas in Google Sheets

Leave a Reply

Your email address will not be published.