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.