SORTBY returning two columns
Return names and teams ordered by a score you keep private.
Task:
The shortlist shows candidate and team, best interview score first, without revealing the scores. In E2, return columns A and B ordered by the score in C, 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.
- 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 | F | |
|---|---|---|---|---|---|---|
| 1 | Candidate | Team | Score | Candidate | Team | |
| 2 | T. Adams | Data | 71 | |||
| 3 | U. Baptiste | Product | 88 | |||
| 4 | V. Chen | Data | 93 | |||
| 5 | W. Diallo | Design | 64 | |||
| 6 | X. Eriksen | Product | 79 |
What this exercise teachesMay contain the answer
The by_array only has to match the height of the array, not sit inside it. That separation is what lets the ordering use data the output leaves out.