ranking by mutliple categories

D

dbr

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

Domenic

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!
 
Top