## What is SEQUENCE function in Excel?

The **SEQUENCE** function is one of the **MATH** functions of Excel.

It Returns **A SEQUENCE **of numbers.

We can find this function in **math** category of insert function Tab.

## How to use SEQUENCE function in excel

- Click on
**an empty cell**(like F5 ).

2. Click on the** fx icon** (or press** shift+F3**).

3. In the **insert function tab** you will see all functions.

4. Select **math** category.

5. Select **SEQUENCE **function.

6. Then select **ok**.

7. In the function arguments Tab, you will see **SEQUENCE function**.

8. **Rows** is the number of rows to return.

9. **Columns** are the number of columns to return.

10. **Start** is the **first **number in the SEQUENCE.

11. **Step** is the amount to **increment **each subsequent **value **in the SEQUENCE.

12. You will see the **result **in the formula result section.

## Examples of **SEQUENCE** function in excel

**Example 1:**

**How to use SEQUENCE function in excel**

You can see examples of SEQUENCE function below:

In this **example**, we want to generate numbers in **5 rows** and **2 columns** that Start from **5,** and the step value is **4**:

## What is the purpose of **SEQUENCE** function?

**SEQUENCE**

It Returns **A SEQUENCE **of numbers.

## What is the Return value of **SEQUENCE** function?

**SEQUENCE**

It returns a number.

## How many arguments does **SEQUENCE** function have?

**SEQUENCE**

This function has just **4** Argument.

The **argument **of SEQUENCE function is **number**.

**Rows** is the number of rows to return.

**Columns** are the number of columns to return.

**Start** is the **first **number in the SEQUENCE.

**Step** is the amount to **increment **each subsequent **value **in the SEQUENCE.

The argument of SEQUENCE function is **required **and not optional.

```
SEQUENCE(number) = number
```

## Which version of excel supports **SEQUENCE** function?

**SEQUENCE**

This function is available for all excel **versions **(2003-2019)

## Errors in **SEQUENCE** function

**SEQUENCE**

## SEQUENCE** related functions :**

- UNIQUE function
- FILTER function
- SORT function
- SORTBY function