Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking question
Hi. I am trying to rank some data as follows:
by total by group then the rest examples John East 150 Bill East 125 Steve South 170 Bob East 100 Jim West 120 Joe West 110 Mike South 105 I want to rank like this 1 Steve South 170 2 John East 150 3 Jim West 120 4 Bill East 125 5 Joe West 110 6 Mike South 105 7 Bob East 100 Any ideas? i can rank by overall, but I want to do by the top in each area then the rest Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking Question | Excel Worksheet Functions | |||
2 part ranking question | Excel Discussion (Misc queries) | |||
Ranking question (ties) | Excel Discussion (Misc queries) | |||
Ranking formula question? | Excel Discussion (Misc queries) | |||
Another ranking question | Excel Worksheet Functions |