Excel SEQUENCE Function

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

  1. Click on an empty cell (like F5 ).
an empty cell in excel

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

 fx icon in excel

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

insert function tab in excel

4. Select math category.

5. Select SEQUENCE function.

6. Then select ok.

excel SEQUENCE function.

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.

How to use SEQUENCE function in excel

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:

Examples of SEQUENCE function in excel

What is the purpose of SEQUENCE function?

It Returns A SEQUENCE of numbers.

What is the Return value of SEQUENCE function?

It returns a number.

How many arguments does SEQUENCE function have?

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?

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

Errors in SEQUENCE function

SEQUENCE related functions :

  • UNIQUE function
  • FILTER function
  • SORT function
  • SORTBY function

Leave a Reply

Your email address will not be published. Required fields are marked *