SEQUENCE

• How to use SEQUENCE formula?
• Examples of using SEQUENCE formula
• SEQUENCE formula not working?
• Similar formulas to SEQUENCE

Usage

Use the SEQUENCE formula with the syntax shown below, it has 2 required parameters and 2 optional parameters:

=SEQUENCE(rows, columns, start, step)

1. rows (required):
   The number of rows in the output array. Must be a positive integer or a reference to a cell containing a positive integer.
2. columns (required):
   The number of columns in the output array. Must be a positive integer or a reference to a cell containing a positive integer.
3. start (optional):
   The starting value of the sequence. If omitted, defaults to 1. Can be any number or a reference to a cell containing a number.
4. step (optional):
   The step size between each number in the sequence. If omitted, defaults to 1. Can be any number or a reference to a cell containing a number.

Examples

Generate a matrix of sequential numbers

To generate a matrix of sequential numbers, use the SEQUENCE function with the desired number of rows and columns, and specify the starting value and step size if necessary. For example, =SEQUENCE(3, 3, 1, 1) will return a 3x3 matrix of sequential numbers starting at 1 and incrementing by 1.

Create a custom sequence of numbers

To create a custom sequence of numbers, use the SEQUENCE function with the desired number of rows and columns, and specify the starting value and step size. For example, =SEQUENCE(5, 1, 0, 0.5) will return a column of 5 numbers starting at 0 and incrementing by 0.5.

Create a range of dates

To create a range of dates, use the SEQUENCE function with the desired number of rows and columns, and specify the starting date and step size. For example, =SEQUENCE(7, 1, DATE(2022, 1, 1), 1) will return a column of 7 dates starting at January 1st, 2022 and incrementing by 1 day.

Common Mistakes

Incorrect number of arguments

Users may forget to include all required arguments or include too many arguments.

Invalid data type

Users may provide non-numeric values for arguments where numeric values are expected.

Invalid range

Users may provide a range that exceeds the available space in the sheet, causing errors or unexpected results.

Incorrect starting value

Users may provide a starting value that is not compatible with the step value, causing unexpected results.

Incorrect step value

Users may provide a step value that does not result in the desired sequence or causes errors.

Related Formulas

The following functions are similar to SEQUENCE or are often used with it in a formula:

• ROW

  The ROW formula returns the row number of a specified cell reference. If no cell reference is provided, it returns the row number of the cell in which the formula is entered. This formula is most commonly used for data analysis and manipulation.

• COLUMN

  The COLUMN formula returns the column number of a given cell reference. It is most commonly used as a helper function for other formulas that require the column number as an argument.

• INDEX

  The INDEX formula in Google Sheets is used to return a value or reference of a cell at the intersection of a specified row and column in a given range. The formula is commonly used to lookup and retrieve values from a table or range of cells.

• ARRAYFORMULA

  The ARRAYFORMULA formula in Google Sheets allows for the application of a formula to an entire column or range of data, without needing to manually copy the formula to each cell. It is most commonly used to simplify and automate complex calculations across large data sets.

• TRANSPOSE

  The TRANSPOSE formula in Google Sheets allows you to flip a table of data by turning rows into columns and columns into rows. This can be useful for reorganizing data or preparing it for use in other formulas.

Learn More

You can learn more about the SEQUENCE Google Sheets function on Google Support.