Sort Function

The SORT function allows you to sort data ranges based on values in one or more columns. This is useful for organizing data and analyzing information in a more digestible format. One of the main advantages of the SORT function is that it uses dynamic arrays, meaning the data automatically updates when values in the table change. This ensures that you always see the most up-to-date information without having to manually resort the data.

Syntax

SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])

• range - The data to be sorted;
• sort_column - The column index in the range or a range outside the specified range containing values for sorting;
  • The range specified as sort_column must be a single column with the same number of rows as the range;
• is_ascending - TRUE or FALSE (1 or -1), indicating whether the sort_column should be sorted in ascending order FALSE sorts in descending order;
• sort_column2, is_ascending2... - [OPTIONAL] Additional columns and sort order flags, specified in order of priority.