Hi,
I have the following table;
<tbody>
A
B
1
Alex
60
2
Brad
60
3
Chris
50
4
Dave
60
5
Elli
70
</tbody>
I then rank 1 to 5 from highest to smallest. Using =LARGE(B:B,1), =LARGE(B:B,2) and so on down to =LARGE(B:B,5)
According to the value of each ranked item in column...