SORT
Returns a range which is sorted based on values in one or more columns.
Returns a range which is sorted based on values in one or more columns.
SORT(range; sortColumn1; sortOrder1; …; sortColumnN; sortOrderN)
range - the range which is to be sorted - Value type: range
sortColumn1-N - the column which is used to sort range - Value type: a column range
sortOrder1-N - the sort order - Value type: constant
up - range is sorted ascending
down - range is sorted descending
In this example, the SORT function returns the content of table1, sorted upwards by the values in its second column:
