Exercises / Statistics that matter at work · 2 of 6
The runner-up score
LARGE(range, k) returns the kth largest value: k = 1 is the maximum, k = 2 the second largest. SMALL works the same from the bottom.
Your taskIn E2, use LARGE to return the second-highest number of points in B2:B9.
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 | Measure | Value | |
| 2 | Arta | 1840 | Runner-up | ||
| 3 | Bilal | 2315 | |||
| 4 | Chloe | 1975 | |||
| 5 | Dren | 2640 | |||
| 6 | Esme | 2105 | |||
| 7 | Felix | 1720 | |||
| 8 | Gaia | 2480 | |||
| 9 | Hugo | 2010 |