# SEQUENCE

The `SEQUENCE` function generates a sequence of numbers in an array. It is most commonly used to create a matrix of sequential numbers with a defined number of rows and columns. The sequence starts at a specified number and increments by a specified step size.

## Usage

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

Parameters:
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

Here are a few example use cases that explain how to use the `SEQUENCE` formula in Google Sheets.

### 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

`SEQUENCE` not working? Here are some common mistakes people make when using the `SEQUENCE` Google Sheets Formula:

### 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.

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.

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