SORT function in Excel

Syntax

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

Example

=SORT(FILTER(A2:C10,C2:C10>1000),3,-1) lists the big sales, largest first.

From the lesson FILTER with Multiple Conditions.

Common mistakes

• Using AND() inside FILTER: it returns one value for the whole range, not one per row.
• Forgetting the brackets around each test.
• Leaving data below the formula, which causes #SPILL!.

Related dynamic array functions

• UNIQUEReturns the unique values in a range (spills).
• FILTERReturns rows that meet a condition (spills).
• SEQUENCEGenerates a list of numbers (spills).
• LETNames intermediate results inside one formula.
• LAMBDABuilds a reusable custom function; give it a name in Define Name.