ranking by mutliple categories
 

i have a list of scores with mutliple groups that i am trying to rank within
each group. the RANK function only lets you rank by one range and not by the
group within the range. I am sure i can figure out a macro to accomplish it,
but i would prefer a formula.

ranking by mutliple categories
 

Assuming that A2:A10 contains the group, and B2:B10 contains the score,
try...

C2, copied down:

=SUMPRODUCT(--($A$2:$A$10=A2),--(B2<$B$2:$B$10))+1

Hope this helps!

In article ,
dbr wrote:

i have a list of scores with mutliple groups that i am trying to rank within
each group. the RANK function only lets you rank by one range and not by the
group within the range. I am sure i can figure out a macro to accomplish it,
but i would prefer a formula.

ranking by mutliple categories
 

This worked perfectly, thanks so much.

"dbr" wrote:

i have a list of scores with mutliple groups that i am trying to rank within
each group. the RANK function only lets you rank by one range and not by the
group within the range. I am sure i can figure out a macro to accomplish it,
but i would prefer a formula.