SORTBY is another of the new dynamic array functions that, unlike the SORT function, arange data within arrays based on other given arrays in ascending or descending order. The application of this function is that you can sort the given range first by the criteria in one column and then by those in another. Let’s see how this works!
SORT is a new Excel function that generates a dynamic array of sorted values based on specified criteria. It allows us to specify the range of values to be sorted, to select columns, sorting order as well as how the data is being recorded, i.e. whether the sorting is done according to the data contained in the rows or according to those contained in the columns.
Sometimes you have repeating values in the column and you want to extract only their unique instances. The Remove Duplicates option is used to do this, and the UNIQUE is a new Excel function that has been built to perform the same thing. It generates a dynamic array with unique values, whether it contains text, numbers, dates …
The SEQUENCE is another function that manipulates dynamic arrays. It allows generation of an array of numbers within a vector or matrix, depending on the given parameters, and it is possible to set the initial value as well as the step value by which the series is being incremented. So, it’s something like when you use the Fill Series option, except that you can now do it with the function.
One of the previous “recipes” was about randomly generated numbers, ie the use of the RANDBETWEEN function. The RANDARRAY function works similarly to the fact that, unlike the one mentioned above, it generates a random range of numbers (vector or a matrix) based on previously specified rules. This is one of the new Excel functions that is available only to Office 365 subscribers. Let’s see how it is works!