SORT in Google Sheets
SORT returns a sorted copy of a range, leaving the original data untouched: =SORT(A2:C50, 3, FALSE) sorts by the third column, largest first.
Add more column/order pairs to break ties: =SORT(A2:C50, 2, TRUE, 3, FALSE) sorts by region A–Z, then by sales high–low within each region. Because it is a formula, the sorted view updates whenever the source changes, unlike Data → Sort range.
Syntax
=SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, …])
Example
=SORT(A2:C50, 3, FALSE)
A leaderboard sorted by score, highest first.
Common mistakes
- Including the header row, which gets sorted into the data.
- Using a column letter instead of the column number within the range.
- Not leaving enough empty space for the results.
← UNIQUE · FILTER → · All lessons