Ranking By Multiple CriteriaOct 3, 2008
I have attached an example worksheet of something that I am working on. My references refer to this sheet.
B = agents.
C = the agent's supervisor.
D = the agent's score.
E = the agent's overall rank in comparison to all other agents.
*F = the agent's rank in comparison to the other agents on the supervisor's team.
I need a formula (non-VBA) that will fill column F. That is, a formula that will compare agents on a specific team, based on their QA scores. Though the example data range is small, this will be applied to roughly 600 agents, split up among roughly 40 supervisors. I am currently using Excel 2007.
If anybody has any ideas, suggestions, or solutions, I would greatly appreciate the help, as I have been beating my head against the desk in my attempt to figure this out.