Sorts rows of data in ascending order on the values contained in a given column.
Syntax:
SORT( data:Range or Array, column_index:Number )
Sorts rows in the data range of cells (or array) in ascending order based on the values in the column specified by column_index.
Example:
SORT(B1:E100, 2)
sorts data from the range B1:E100
by row based on the contents of column C
.
Note that it does NOT affect the content of the source range.
Use FLIP() on the result of SORT() to sort in descending order.
Use TRANSPOSE() prior to SORT() to sort by column based on values in rows.