Magazine Notes

There are three columns: name, group, and score. You want the people ranked within groups. This describes the solution. The original problem was posed by a band director that had tryouts for the various instruments and needs to rank the people within instruments. It could also be used by a teacher with scores for the members of a group of students, and other things.

The key is the formula =B2&" "&SUM(IF(B2=Inst,IF(C2 <=Score,1,0),0)) which is fully explained in the article.

PC Magazine, December 14, 2005, p. 96: Solution from PC Magazine: Advanced Ranking in Excel