Functions

SORT

Sorts an array

Try it

When to use it

When should I use SORT?

Use SORT to return a sorted copy of an array or range without modifying the original data, optionally specifying a sort column and ascending or descending order.

Used in

operations · science

Syntax

SORT(array, [sort_index], [sort_order], [by_col])

Examples

=SORT({3,1,4,1,5,9,2,6}) // => 3
=SORT({3,1,4,1,5,9,2,6},1,FALSE) // => 3
=SORT({3,30;1,10;2,20},1,TRUE) // => 1

SMALL

k-th smallest value

SORTBY

Sorts an array based on the values in corresponding arrays