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