Exercises / Modern Excel: dynamic arrays · 5 of 12
Names in score order
SORTBY(range, by_range, [order]) sorts one range by the values of another. The sort key does not have to be part of the result.
Your taskIn D2, use SORTBY to list the player names from A2:A9 in order of their points in B2:B9, highest first.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Player | Points | Ranking | |
| 2 | Arta | 1840 | ||
| 3 | Bilal | 2315 | ||
| 4 | Chloe | 1975 | ||
| 5 | Dren | 2640 | ||
| 6 | Esme | 2105 | ||
| 7 | Felix | 1720 | ||
| 8 | Gaia | 2480 | ||
| 9 | Hugo | 2010 |