Organize a range or array.

`SORT(array,[sort_index],[sort_order],[by_column])`

- array - range or array to sort
- sort_index - [OPTIONAL] number that indicates the row or column to be sorted
- sort_order - [OPTIONAL] number indicating the sort order
- by_col - [OPTIONAL] logical value indicating the sort direction

`=SORT(range)`

The SORT function can be used to sort data in a Sourcetable worksheet. This example will sort the data by the first column in the range in ascending order.

`=SORT(range,1,1)`

The SORT function can also be used to sort by a specific column and order, where the 1 after the range is the column number that will be used to sort the data, and the 1 after that is the order. This example will sort the data by the first column in ascending order.

`=SORT(range,1,-1)`

The SORT function can also be used to sort by a specific column and order.This example will sort the data by the first column in descending order.

The SORT function is a useful tool to easily organize data by sorting an array or range according to a specified criterion. It returns an array of the sorted elements. The SORTBY function is a better choice when sorting data in the grid.

- The SORT function can sort data in one or more columns, returning a #VALUE! error if the sort_index, sort_order, or by_col is out of range.
- The SORT function sorts a dynamic array of results.

The SORT function is used to sort a range or array of elements. It returns an array of the sorted elements.

The SORTBY function allows you to sort data in a table by referencing a specific column. It also respects column additions and deletions.

The SORT function can be used for a variety of purposes, such as sorting a list of names alphabetically, sorting a list of numbers from smallest to largest, or sorting data in a table by a specific column.

To reference a column in a table using SORTBY, simply include the column name in the parameters of the SORTBY function. For example, if you wanted to sort a table by the "Last Name" column, you would use the following code: SORTBY(TableName, "Last Name").

Drop CSV