← Back to level 2
Level 2Next
SORT
A medium dynamic array formula that reorders a list in ascending, descending, or custom order.
Syntax
=SORT(...)Step-by-step explanation
- 1Select the list or table that will be processed by the dynamic array formula.
- 2Add the filter or sorting rule so Excel knows which rows to return.
- 3Check the spilled output to make sure the visible results match the rule.
Common mistakes
Blocking the spill area
Sorting a range that does not include related columns
Expecting it to work in older Excel versions
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=SORT(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =SORT(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use SORT when you want live data to appear in a cleaner order automatically.
Match against the syntax block above.