centurions
New Member
- Joined
- Aug 12, 2017
- Messages
- 3
Hi I am having troubles trying to get a ranking formula to work for more than 1 student easily. I have managed to get it to work for 1 student fine but then looking for a way to copy the formula easily to the students underneath such as in the picture. Any help would be appreciated.
For example;
John Smith 87 2
98 1
23 3
12 4
The formula I used for John was =RANK.EQ(C3,$C$3:$C$8,0)
Jill Jones 91
23
21
78
Is there an easy to transfer the formula down to Jill and a large number of students underneath her if I have a large list of students. I have used the rank formula to do John Smith but can't find an easy way to move it to subsequent students.
For example;
John Smith 87 2
98 1
23 3
12 4
The formula I used for John was =RANK.EQ(C3,$C$3:$C$8,0)
Jill Jones 91
23
21
78
Is there an easy to transfer the formula down to Jill and a large number of students underneath her if I have a large list of students. I have used the rank formula to do John Smith but can't find an easy way to move it to subsequent students.
