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.

[TABLE="width: 290"]
<tbody>[TR]
[TD]Agent[/TD]
[TD]Calls[/TD]
[TD]Transfer %[/TD]
[/TR]
[TR]
[TD]Teresa StJohn[/TD]
[TD]18631[/TD]
[TD]4.879%[/TD]
[/TR]
[TR]
[TD]Laasa Palmer[/TD]
[TD]22671[/TD]
[TD]3.965%[/TD]
[/TR]
[TR]
[TD]Christina Carson[/TD]
[TD]31722[/TD]
[TD]4.212%[/TD]
[/TR]
[TR]
[TD]Robert Fischer[/TD]
[TD]26394[/TD]
[TD]4.459%[/TD]
[/TR]
[TR]
[TD]Sara Obrien[/TD]
[TD]26194[/TD]
[TD]3.657%[/TD]
[/TR]
[TR]
[TD]Brenda West[/TD]
[TD]20406[/TD]
[TD]3.749%[/TD]
[/TR]
[TR]
[TD]Anteneka Wells[/TD]
[TD]33577[/TD]
[TD]2.272%[/TD]
[/TR]
[TR]
[TD]Elizabeth Aguiar[/TD]
[TD]27125[/TD]
[TD]3.650%[/TD]
[/TR]
[TR]
[TD]Shaheto Martin[/TD]
[TD]18330[/TD]
[TD]2.990%[/TD]
[/TR]
[TR]
[TD]Steven Day[/TD]
[TD]32479[/TD]
[TD]3.544%[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 290"]
<tbody>[TR]
[TD]Amber Garris[/TD]
[TD]21602[/TD]
[TD]3.889%[/TD]
[/TR]
[TR]
[TD]Scott Levinson[/TD]
[TD]21469[/TD]
[TD]3.531%[/TD]
[/TR]
[TR]
[TD]Christopher Hamlin[/TD]
[TD]12458[/TD]
[TD]3.757%[/TD]
[/TR]
[TR]
[TD]Deborah Mendoza[/TD]
[TD]24429[/TD]
[TD]3.394%[/TD]
[/TR]
[TR]
[TD]Meshell Patterson[/TD]
[TD]25657[/TD]
[TD]2.947%[/TD]
[/TR]
[TR]
[TD]Lawrence Kelly[/TD]
[TD]30398[/TD]
[TD]3.405%[/TD]
[/TR]
[TR]
[TD]LaShawn Williams[/TD]
[TD]25229[/TD]
[TD]3.211%[/TD]
[/TR]
[TR]
[TD]Dominique Lane[/TD]
[TD]17925[/TD]
[TD]3.944%[/TD]
[/TR]
[TR]
[TD]Amber Miller[/TD]
[TD]28242[/TD]
[TD]2.790%[/TD]
[/TR]
[TR]
[TD]Marc Collins[/TD]
[TD]27400[/TD]
[TD]3.438%[/TD]
[/TR]
</tbody>[/TABLE]

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".