Show Ranking
 

Excel 2003
I'm looking for a way to show a current rank that updates as data is input.
In my example the higher the percentage the better the rank- ie. 1st, 2nd,
or 3rd.
How do I get C13 thru G13 to show the current rank
B C D E F G
2 Percentage Lost
3 Day Adam Jack Stacy Emily Jamie
4 Monday 0.00% 0.00% 0.00% 0.00% 0.00%
5 Friday 1.49% 1.55% 0.00% 1.93% 1.98%
6 Tuesday 2.48% 1.94% 0.80% 1.45% 2.48%
7 Friday 2.97% 2.71% 1.61% 2.90% 3.96%
8 Tuesday
9 Friday
10 Tuesday
11 Wednesday
12 Monday
13 Rank ? ? ? ? ?

Show Ranking
 

I got it....

In C14 thru G14 I used this formula....
=LOOKUP(2,1/(C4:C12<""),C4:C12)-C4

Then this formula in C13 thru G13 for the ranking...
=RANK(C14,$C$14:$G$14,0)


"Jamie" wrote:

Excel 2003
I'm looking for a way to show a current rank that updates as data is input.
In my example the higher the percentage the better the rank- ie. 1st, 2nd,
or 3rd.
How do I get C13 thru G13 to show the current rank
B C D E F G
2 Percentage Lost
3 Day Adam Jack Stacy Emily Jamie
4 Monday 0.00% 0.00% 0.00% 0.00% 0.00%
5 Friday 1.49% 1.55% 0.00% 1.93% 1.98%
6 Tuesday 2.48% 1.94% 0.80% 1.45% 2.48%
7 Friday 2.97% 2.71% 1.61% 2.90% 3.96%
8 Tuesday
9 Friday
10 Tuesday
11 Wednesday
12 Monday
13 Rank ? ? ? ? ?
14