RANK.EQ: positions in a list
Exercise 1 of 3
In D2, find Ana's rank in the class, with the highest score as 1. Write it so it could be copied down.
About this lesson
RANK.EQ gives each value its position in a list, such as a student's place in the class.
In this lesson
- In
D2, find Ana's rank in the class, with the highest score as 1. Write it so it could be copied down. - In
D5, find Dev's rank counting from the lowest score. - Chloé and Hana both scored 91, the highest score. What ranks do
RANK.EQgive them, and what rank comes next?
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in D2 and press Enter to check.