Instructor: Okay, mow that we've talked about
dynamic array behavior and functionality
and things like spill range and spill properties,
let's take a look at Excel's brand new set
of dynamic array functions.
Now we're gonna be focusing on
six new functions here in the course, sort,
sort by, filter, unique, sequence, and rand array.
I'm gonna give you a quick introduction to each of these now
and then we're gonna dig into each of them in turn
with hands-on demos and exercises in the upcoming lessons.
So first and foremost, sort, very straightforward
allows you to sort an array of data
by one or more columns contained within that array.
Sort by works just like sort, except you can sort
by columns from another separate array.
Filter, one of my favorites.
Filter functions allow you to filter an array of source data
based on specific criteria and only return
the matching records in the spill range.
Unique, another one of my favorites here,
this one's a game changer,
allows you to remove duplicates from an array of data
and return only the unique records.
Sequence is a great tool for generating
one or two dimensional arrays of sequential numbers
based on a given start number and step.
And then finally, rand array generates
a one or two dimensional array of random numbers.
So those are Excel's brand new dynamic array functions.
Let's jump right into the demos
and put these things to work.