Using "RANK.EG"

[GoPackGo]

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.

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

 

[mole999]

have you looked at pivot tables, you cant sort from high to low on a related page without damaging your table

 

[GoPackGo]

have you looked at pivot tables, you cant sort from high to low on a related page without damaging your table

Mole999, thanks for the quick reply. I don't necessarily want to sort them, just get the overall rankings, based on the transfer percent, in the third column. Do you know if it can be done?

 

[GoPackGo]

I'm very sorry. That should say "RANK.EQ", not "RANK.EG".