Solved

# How do I rank by category in iWork Numbers

Posted on 2009-07-14

I have a list of competitors, they all have an age class and a score. The table is categorized by the class and sorted by score. I would like to add another column with the competitors rank in each class.

I have searched for an excel formula to rank by category and found this:

A2:A20 = class

C2:C20 = score

Enter this formula in D2 and copy down as needed:

=SUMPRODUCT(--(A$2:A$20=A2),--(C2<C$2:C$20))+1

I don't understand what is going on here and it doesn't appear to work in numbers.

Please help.