SORT text A to Z
With no other arguments, SORT orders text alphabetically.
Task:
The guest list was typed in the order people replied. In C2, produce the same names in alphabetical order for the door list, without touching column A.
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 | |
|---|---|---|---|
| 1 | Guest | Door list | |
| 2 | Wright | ||
| 3 | Adeyemi | ||
| 4 | Nakamura | ||
| 5 | Baker | ||
| 6 | Okonkwo | ||
| 7 | Evans |
What this exercise teachesMay contain the answer
The reply order is worth keeping — it tells you who answered first — so sorting the source in place would lose information. A spilled, sorted copy gives the door staff what they need and updates when a late reply is added.