Instructor: Alright, we talked about
four of the core dynamic array functions already.
Sort, sort by, filter, and unique.
But there are two more that I want to cover, as well.
The first of which being sequence.
Now, what sequence does
is it generates either a one dimensional
or a two-dimensional array of sequential numbers.
Syntax wise, it's very simple,
only one required parameter or argument
which is the number of rows you want to generate or return,
followed by three optional parameters.
You've got a columns argument,
which allows you to specify the number of columns to return
If you choose to build a two dimensional array.
You can also specify the starting number
where the default is a one.
And then finally, you can specify the step
or the increment between each number in the array.
Again, the default being a one.
So to visualize exactly what this looks like,
consider an example like this.
In this sequence function we're using a row argument of 10,
a column argument of six, a start number of 10,
and a step of five and basically what that produces
or generates is a 10 row, six column array
that starts at the number 10 and increments by five.
The important thing to note here
is that our numbers go left to right first
and then down, row by row.
Little tip here, this is one of those functions in Excel
that you very rarely use on its own.
Sequence is almost always combined
or nested within other functions
to make them more flexible or dynamic.
And that's exactly what we're gonna show you
in the next demo where we're gonna combine sequence
with functions like large and filter
to do some really powerful things.
Stay tuned.