SORTBY function
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!