Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial

Date:2022-4-24 Author:Sandra

Today, we are going to learn the usage of the SEQUENCE Function. Learning to use functions can always make complicated things to be easier.

The Syntax of SEQUENCE Function:

=SEQUENCE (rows,[columns],[start],[step])

Rows: The number of rows to be returned.

Columns: The number of columns to be returned. The default value is 1. (Optional)

Start: Starting value. The default value is 1. (Optional)

Step: the increment of each step between values. The default value is 1. (Optional)

How to use it?

The SEQUENCE function can return a sequence of numbers according to the syntax.

If we enter =SEQUENCE(3,3,1,5) in cell B3 and press enter.

Then we will get a sequence of numbers in 3 rows, 3 columns, and starting number would be 1, and each number differs by 5.

How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial
How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial

I guess you might think this doesn’t seem very practical in daily work. Now, let’s try something new.

Let’s take an easy example. Here are 30 names in one list, column A. If we need to print the name list. It would be too long. So, we can use the SEQUENCE function to shift these names into several columns.

How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial
How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial

Enter =INDEX(A:A,SEQUENCE(E2,E3,2))&” ” in Cell D5, and press Enter key.

How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial

You can change the number of rows and columns. The sequence of numbers would be changed automatically at the same time.

How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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