Function reference

SORT in Excel & Google Sheets

SORT is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 beginnerBuild a custom SORT formula →

When to use SORT

Display a leaderboard sorted by score, show a product list alphabetically, or output a FILTER result in sorted order.

Worked examples (1)

Array Formulasbeginner

Sort a range dynamically with SORT

=SORT(A2:B20,2,-1)

Open formula SORT reference

Common errors with SORT

SORT is not available

SORT requires Excel 365 or Excel 2021. Use the Data > Sort menu for static sorting in older versions.

Sorted output does not update

SORT is dynamic — it updates whenever the source data changes. If it appears static, check that calculation is set to Automatic in Formulas > Calculation Options.

Frequently asked questions

How do I sort by multiple columns?

Use arrays for the sort index and order — =SORT(A2:C20,{2,3},{1,-1}) sorts by column 2 ascending first, then column 3 descending for ties.

Need a custom variation?

Describe your specific SORT problem and get a formula written for your exact data.

Open generator with SORT