Exercises / Statistics that matter at work · 4 of 6
Rank every player
RANK.EQ(number, range, [order]) gives a value its position in a list: 1 for the largest by default, or for the smallest with order 1. Ties share a rank.
Your taskIn C2, use RANK.EQ to rank the points in B2 against all points in B2:B9, highest = 1. It will be copied down to C9.
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 |
|---|---|---|---|
| 1 | Player | Points | Rank |
| 2 | Arta | 1840 | |
| 3 | Bilal | 2315 | |
| 4 | Chloe | 1975 | |
| 5 | Dren | 2640 | |
| 6 | Esme | 2105 | |
| 7 | Felix | 1720 | |
| 8 | Gaia | 2480 | |
| 9 | Hugo | 2010 |