Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced(!) Ranking
Hi
I need to enter a ranking, but am really struggling, I've been given some great formulae using sumproduct, but, being no expert I'm not sure quite how to use this for what I want, which is: I have x columns of data, Region Manager, Area Manager, Sales person, Average Score for Area Manager (based on a score for each sales person) I need a column to represent the ranking of the Average Score within its area. The resulting column should look something like RANK below - so, does anyone have any idea what this formula may be - Thanks in advance RM AM SP Score Average Score RANK AR1 AM1 SP1 1 1.5 3 AR1 AM1 SP2 2 1.5 3 AR1 AM2 SP3 3 3.5 2 AR1 AM2 SP4 4 3.5 2 AR1 AM3 SP5 5 6 1 AR1 AM3 SP6 6 6 1 AR1 AM3 SP7 7 6 1 AR2 AM4 SP8 8 9.25 2 AR2 AM4 SP9 9 9.25 2 AR2 AM4 SP10 10 9.25 2 AR2 AM4 SP11 11 9.25 2 AR2 AM5 SP12 12 13 1 AR2 AM5 SP13 13 13 1 AR2 AM5 SP14 14 13 1 AR2 AM6 SP15 1 1 3 AR2 AM6 SP16 1 1 3 AR2 AM6 SP17 1 1 3 -- Marie Bayes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced(!) Ranking
Just to clarify as my table below is not 100% accurate(!), the highest
average score should be ranked first. -- Marie Bayes "Marie Bayes" wrote: Hi I need to enter a ranking, but am really struggling, I've been given some great formulae using sumproduct, but, being no expert I'm not sure quite how to use this for what I want, which is: I have x columns of data, Region Manager, Area Manager, Sales person, Average Score for Area Manager (based on a score for each sales person) I need a column to represent the ranking of the Average Score within its area. The resulting column should look something like RANK below - so, does anyone have any idea what this formula may be - Thanks in advance RM AM SP Score Average Score RANK AR1 AM1 SP1 1 1.5 3 AR1 AM1 SP2 2 1.5 3 AR1 AM2 SP3 3 3.5 2 AR1 AM2 SP4 4 3.5 2 AR1 AM3 SP5 5 6 1 AR1 AM3 SP6 6 6 1 AR1 AM3 SP7 7 6 1 AR2 AM4 SP8 8 9.25 2 AR2 AM4 SP9 9 9.25 2 AR2 AM4 SP10 10 9.25 2 AR2 AM4 SP11 11 9.25 2 AR2 AM5 SP12 12 13 1 AR2 AM5 SP13 13 13 1 AR2 AM5 SP14 14 13 1 AR2 AM6 SP15 1 1 3 AR2 AM6 SP16 1 1 3 AR2 AM6 SP17 1 1 3 -- Marie Bayes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced(!) Ranking | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |