Explanation
The SORT function sorts a range using a given index, calledsort_index.
Normally, this index represents a column in the source data.
This result is dynamic; if any scores in the source data change, the results will automatically update.
With SORTBY
TheSORTBY functioncan also be used to solve this problem.
Values can be sorted by one or more columns.
SORT returns a dynamic array of results.
The range or array used to sort does not need to appear in results.
