SORTBY ascending: most urgent first
Order a list by a priority number that is not shown.
Task:
The job list should run in priority order, where 1 is most urgent, but the priority column itself is internal. In E2, list just the job names ordered by priority, smallest 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.
- Order one column by the values in another
SORTBY sorts a range using a separate range as the key.
CoreIntermediate - SORTBY ascending: most urgent first
Order a list by a priority number that is not shown.
Intermediate - SORTBY returning two columns
Return names and teams ordered by a score you keep private.
Intermediate
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 | Job | Site | Priority | Today's order | |
| 2 | Boiler service | Leeds | 3 | ||
| 3 | Burst pipe | York | 1 | ||
| 4 | Radiator bleed | Hull | 5 | ||
| 5 | No hot water | Selby | 2 | ||
| 6 | Tap washer | Ripon | 4 |
What this exercise teachesMay contain the answer
SORT can only order by a column it returns, so it would have to show the priorities. SORTBY uses a separate key, so the output is just the names, in the order the key dictates — exactly what goes on a technician's phone.