Get rank from range

Hi All,

I have and table that gets the average performance of couriers as a %.

so...

courier 1...courier 2...courier 3...courier 4,
98.16.......100...........99.7...........99.72

...what i want is a formula (hoping note to have to code this) that will show which order these couriers should be ranked in by looking at the range of averages.

So courier2(100) would be ranked 1st, courier 4(99.7) would be ranked 2nd etc..

the end table will look something like..

courier 1...courier 2...courier 3...courier 4,
98.16.......100...........99.7...........99.72
4..............1...............3................2


Is it do-able???

Many Thanks.

=rank(a7;$a$7:$g$7;0) and extend to right

Please Login or Register  to view this content.