Exercises / Modern Excel: dynamic arrays · 10 of 12
Top three in one formula
TAKE(array, rows) keeps the first rows of an array, or the last ones with a negative number. TAKE(SORT(…), 3) is a live top 3.
Your taskIn D2, use TAKE and SORT to return the three players with the most points: the rows of A2:B9 sorted by points, highest first, keeping only the first 3.
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 |