Exercises / Modern Excel: dynamic arrays · 4 of 12
A leaderboard that sorts itself
SORT(range, [column], [order]) returns the range sorted. column is which column to sort by (1, 2, …) and order is 1 for smallest first or -1 for largest first.
Your taskIn D2, use SORT to return the table A2:B9 sorted by points, 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 | E |
|---|---|---|---|---|---|
| 1 | Player | Points | Player | Points | |
| 2 | Arta | 1840 | |||
| 3 | Bilal | 2315 | |||
| 4 | Chloe | 1975 | |||
| 5 | Dren | 2640 | |||
| 6 | Esme | 2105 | |||
| 7 | Felix | 1720 | |||
| 8 | Gaia | 2480 | |||
| 9 | Hugo | 2010 |