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: