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!

SORT function

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.