Excel Dynamic Array Functions Video #2: Unique & Sort Functions with 8 practical examples

Dynamic Array Functions - Video #2
Hello & Welcome to the second video talking about Dynamic Array Functions
These dynamic array function will work only with Office 365 or "Microsoft 365" - the new name.

If you are working with any other version of excel, these functions are not supported.

In this video we are going to present 2 new functions;

First one is UNIQUE() which designed to return a list of unique values in a list or range.
Unique has one required argument which is "Array" and 2 optional arguments, we are going to discuss all them in details

2nd function will be SORT().
The SORT function sorts the contents of a range or array.
SORT() has 4 arguments, with only one required which again the "Array" and the 3 other arguments are all optional, and also we are going to look at them all.

We will discuss these to new functions through 8 examples 4 for each of them

Also during the video, will see how the array function Transpose() will behave under the new calculation engine for office 365, and how can we combie it with the new dynamic array function "UNIQUE()"

To watch the full playlist

To download the working files:
Start file:
End file:

To subscribe to the channel:

To follow on Facebook:

To follow on LinkedIn:

[mahmoudelsayad]

You are extra good I'm learn from you
Good luck for you🌺👍💪👍

[teoxengineer]

And, how can we sort all data with two arguments? For example, first unit column and date column.
Secondly, sortby function is so useful with regard to sorting indepently from main data. Can you prepare for it a video?
Thank you so much this useful tutorial

[kishorpanara]

Sir l want to see the addins of sequence, randarray, filter, unique, xlookup, xmatch, sort and sortby you have it. Pls who to download