Rank the reps without touching the source data
SORT returns a sorted copy and leaves the original alone.
Task:
Your manager wants a leaderboard, but the source table is fed by an import you must not reorder. In E2, use SORT to list the sales figures from C2:C7 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 | |
|---|---|---|---|---|---|
| 1 | Rep | Team | Sales | Ranked | |
| 2 | Ada | North | 4200 | ||
| 3 | Bo | South | 3100 | ||
| 4 | Cy | North | 5800 | ||
| 5 | Dee | East | 2400 | ||
| 6 | Eve | West | 4900 | ||
| 7 | Fin | South | 3600 |
Functions used here
What this exercise teachesMay contain the answer
Sorting in place destroys the row order an import depends on. SORT gives you the view you want next to the data, and it re-sorts itself the moment a number changes.