Organize a range or array.
- 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
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.
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.
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.
Frequently Asked Questions
What is the SORT function?
The SORT function is used to sort a range or array of elements. It returns an array of the sorted elements.
What does SORTBY do?
The SORTBY function allows you to sort data in a table by referencing a specific column. It also respects column additions and deletions.
What are some examples of when you might use the SORT function?
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.
How do I reference a column in a table using SORTBY?
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").