Array Formulasbeginner
Sort a range dynamically with SORT
=SORT(A2:B20,2,-1)
Google Sheets reference
SORT in Google Sheets
Minor differences1 worked example
Worked examples (1)
These formulas work in Google Sheets with the differences noted above.
Also in Excel
See the full SORT reference for Excel — including all worked examples, common errors, and FAQ.
SORT Excel reference →