SORT whole rows by one column
Sort the table, not just the numbers, so names stay with their figures.
Task:
Build a leaderboard that keeps each rep's name and region beside their sales. In E2, sort the whole table A2:C7 by sales, highest first.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of SORT
0/3The same formula in the other shapes it takes at work.
- Rank the reps without touching the source data
SORT returns a sorted copy and leaves the original alone.
CoreBeginner - SORT whole rows by one column
Sort the table, not just the numbers, so names stay with their figures.
Intermediate - SORT text A to Z
With no other arguments, SORT orders text alphabetically.
Beginner
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Rep | Region | Sales | |
| 2 | Mia | North | 41200 | ||||
| 3 | Noah | South | 52800 | ||||
| 4 | Olu | East | 38600 | ||||
| 5 | Pia | North | 60100 | ||||
| 6 | Raf | West | 47500 | ||||
| 7 | Sia | South | 55300 |
What this exercise teachesMay contain the answer
Sorting only the sales column produces numbers with no names attached. Passing the whole table keeps every row together, and the sort_index picks which of its columns decides the order. The source stays exactly as it was.