Good afternoon,
I work in a call center, and we need to rank our agents using several different metrics. Is it possible to use "RANK.EG" using more than one selecton? Attached is a sample of the worksheet I am attempting to rank. I can rank the top, or the bottom, but not both together. Any help would be appreciated.
<tbody>
</tbody>
<tbody>
</tbody>
The blank line indicates where the rank from the top portion of the table is shown. Since there are other numbers in that area, I can't just scroll down, since that would skew the result. If I need to explain better, please let me know.
Thanks, in advance.
Mark
I work in a call center, and we need to rank our agents using several different metrics. Is it possible to use "RANK.EG" using more than one selecton? Attached is a sample of the worksheet I am attempting to rank. I can rank the top, or the bottom, but not both together. Any help would be appreciated.
Agent | Calls | Transfer % |
Teresa StJohn | 18631 | 4.879% |
Laasa Palmer | 22671 | 3.965% |
Christina Carson | 31722 | 4.212% |
Robert Fischer | 26394 | 4.459% |
Sara Obrien | 26194 | 3.657% |
Brenda West | 20406 | 3.749% |
Anteneka Wells | 33577 | 2.272% |
Elizabeth Aguiar | 27125 | 3.650% |
Shaheto Martin | 18330 | 2.990% |
Steven Day | 32479 | 3.544% |
<tbody>
</tbody>
Amber Garris | 21602 | 3.889% |
Scott Levinson | 21469 | 3.531% |
Christopher Hamlin | 12458 | 3.757% |
Deborah Mendoza | 24429 | 3.394% |
Meshell Patterson | 25657 | 2.947% |
Lawrence Kelly | 30398 | 3.405% |
LaShawn Williams | 25229 | 3.211% |
Dominique Lane | 17925 | 3.944% |
Amber Miller | 28242 | 2.790% |
Marc Collins | 27400 | 3.438% |
<tbody>
</tbody>
The blank line indicates where the rank from the top portion of the table is shown. Since there are other numbers in that area, I can't just scroll down, since that would skew the result. If I need to explain better, please let me know.
Thanks, in advance.
Mark