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 https://www.youtube.com/playlist?list=PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if To download the working files: Start file: https://drive.google.com/file/d/1ZlF2Y8OlZ-jS0MyO7zzY13Kxco6QeP_K/view?usp=sharing End file: https://drive.google.com/file/d/1HVZ3xWlvLP8FZM8BlWIDswvUvVbV0Qg0/view?usp=sharing To subscribe to the channel: https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1 To follow on Facebook: https://www.facebook.com/excelispower To follow on LinkedIn: https://www.linkedin.com/in/amratef