SEQUENCE

Back to all functions

The SEQUENCE function generates a given number of rows and columns that contain a list of sequenced counting.

With this function, we can create lists that count up or down at given intervals, but the default of the function is to count 1, 2, 3, 4, 5, and so on.

Let’s start by creating the simplest version of the function, and write =SEQUENCE and Left parenthesis.

The first argument is the number of rows we want, of which we want 10, and when we close the function, we get 10 rows of the default number sequence.

We go into the function and see that the second argument determines how many columns we will have, and for this we enter 5.

We now have an array of 10 rows and 5 columns, and we see that the numbers are counted to the right and resume on the next row.

We go back into the function and see that the third argument determines at which number we want to start, and for this we’ll try 10.

We’ll see that it’s the same sequence as before, but plus 10.

We can also change this number to -10 to start there instead.

We go back in and look at the fourth argument.

Here we determine the amount by which each subsequent value in the array will be increased.

If we leave this blank, as mentioned, it will default to 1, but we’ll try writing 3, and hit enter.

We see that each number now increases by three instead of one.

As a practical example, we can use SEQUENCE to write out the months of the year in a row.

For this we’ll need to use the TEXT function, so we enter =TEXT, left parenthesis.

As the first argument, we’ll start a DATE function, and as its first argument in it we start a YEAR function, which we decide should take in today’s date using the TODAY function.

For the second arguments in the DATE function, we’ll create a SEQUENCE function with 1 row and 12 columns, one for each month, and as the third argument we enter a one to start with January.

We’ll end the DATE function and enter the TEXT function’s second argument, where we enter “mmm” in quotation marks to specify the format we want to show the months in.

We’ll close the function and hit enter, and we now have a dynamically updated list of months, where the months shown will always be in the current year.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.

Contact