Hi everybody,
I need to make a table to include race results.
I have +/- 50 Pilots from several teams.
The pilots are in two different groups and each group has 2 races and the 12 best from each group go into a final race.
Every pilot may get points from 3 differents jurys.
Now I need to get an result for each race and final, each group and an overall result for a raceday.
As well I need an overall result for each team but here only the results from the 6 best pilots of each team should be calculated even though there could be more or less than 6 pilots per team.
Over a year there are 7 racedays.
Is there someone how could help me out with this because I'm stuck.
Many thanks in advance
Bookmarks