Excel Practice - SORT
Instruction
Sort rows in A2:C6 by the 2nd column in descending order.
Formula Syntax
=SORT(array, [sort_index], [sort_order], [by_col])
- array: Source range/array for calculation.
- [sort_index]: Optional column/row index used for sorting.
- [sort_order]: Optional order: 1 ascending, -1 descending.
- [by_col]: Optional TRUE to process by column instead of row.
What it does
Sort array output without editing source data.
dynamic-array-data.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Category | Amount | Region |
| 2 | A | 120 | North |
| 3 | B | 340 | South |
| 4 | A | 560 | North |
| 5 | C | 225 | West |
| 6 | B | 90 | South |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use SORT with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.