calculate ranking

T

tom ossieur

Hi,


given the table below

A B C D F G
1 Activity Edward Louis Anna Emma Ranking
2 A 5 2 6 2 1
3 B 8 2 1 4 4
4 C 2 6 8 4 1
5 D 5 4 6 7 2


How to calculate the last column, i.e. the ranking of Anna?

Thanks!

tom
 
C

CLR

I don't know what happened to column E, but this is the idea.......
In G2, put this and copy down.........

=RANK(D2,B2:F2)

hth
Vaya con Dios,
Chuck, CABGx3
 
Top