All functions / Dynamic arrays
SORTBY
Sorts a range by the values in another range.
Syntax
=SORTBY(array, by_array, [sort_order], [by_array1, [by_array2], …])
Arguments
array: The data to sort.by_array: The values to sort by.sort_order(optional): 1 ascending (default) or -1 descending.by_array(optional): More by_array/sort_order pairs.