| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? ? ? ? ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ranking | New Users to Excel | |||
| Top 10 Ranking again | Excel Discussion (Misc queries) | |||
| Ranking | Excel Discussion (Misc queries) | |||
| Ranking | Excel Worksheet Functions | |||
| Ranking | Excel Discussion (Misc queries) | |||
Threaded Mode
