Abstract
Transcript
In this video, we’ll quickly review newDynamic Arrayfunctions in Excel.
UNIQUE
The UNIQUE function is designed to extract unique values from a set of data.
This range contains a list of colors, some of which appear more than once.
With UNIQUE, I can quickly build a list unique values.
If the source data changes, the list automatically updates.
SORT
As the name implies, the SORT function sorts data.
For example, I can use SORT to sort this data by score in descending order.
If I change a score, the sorted list automatically updates.
SORTBY
The SORTBY function makes it easy to sort by more than one column.
With SORTBY, I supply a range for each column along with a sort direction.
SEQUENCE
The SEQUENCE function is designed to generate numeric sequences.
RANDARRAY
The RANDARRAY function can be used to generate an array of random numbers.
For example, I can generate 10 random decimal values.
Or a grid with 100 random integers between 1 and 100.
The RANDARRAY function can be used inside other formulas to perform random sorts, and random item selection.
FILTER
The FILTER function lets you extract data based on matching criteria.
For example, I can easily extract just the members of the red group.
If the source data changes, the result automatically updates.
XLOOKUP and XMATCH
Finally, I want to mention two other new functions: XLOOKUP and XMATCH.
