Array Functions
Beginner
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.
Learning Objectives:
- Sort without reordering the source
- Control sort direction
- Read a spilled numeric result
Hints
Solve without hints for +5 XP
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 |
What this exercise teaches (contains 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.