ranking based on criteria

[Bob Phillips]

=MATCH(C2,LARGE(IF($B$2:$C$13=B2,$C$2:$C$13),ROW(INDIRECT("1:"&COUNTIF($B$2:
$B$13,B2)))),0)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I am creating a spreadsheet that shows the results of a marching band
competition. The awards are given by class, 1st, 2nd and 3rd place. I will
have the following:

Name Class Score
School 1 A 99
School 2 A 98
School 3 AA 52

etc. If I knew that there would always be X schools in a class, the ranking
formula would be easy. But, for every competition, there could be a different
number of schools in each class. So, I want to enter on sheet 1 the schools,
classes and scores, and on the second sheet have it calculate who got the
best score in class A, who got the best in class AA, and so on.

Possible?