Trying to help out Mrs GF who organises a TT series here in sunny Wales. In each event the fastest person is awarded 120 points, the next fastest 119 etc etc. One of the series awards is the fastest 5, so for each event in the series (there are 7 events), the fastest 5 members of any given club qualify for the awards, so if Club X had 7 riders only the fastest 5 would count to this award.
So the excel bit, if you are still with me and not gone to read about wheel sizes or pudding..
From my list of all results in the format name, club, time, points how can I select just the fastest five from each club and add up their points? (I can do it manually, but would love to be able to use a formula if it’s possible)
Thank you!