Sort function

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.

Column	Calculator expression	Result
C1 contains 1, 11, 7, 9, 4	SORT(C1)	1, 4, 7, 9, 11