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:
I don't understand what is going on here and it doesn't appear to work in numbers.