To use this function, choose Calc > Calculator.

Sorts the numerical values in a column in ascending order. Ranked scores are stored in a column.

Syntax

SORT(column)

Specify the column, to sort. Data must be numerical. To sort text or date/time values in a column, use Data > Sort.

Example

Column Calculator expression Result
C1 contains 1, 11, 7, 9, 4 SORT(C1) 1, 4, 7, 9, 11
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy