If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 ? ? ? ? ? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|