Let's see if I can explain this properly. As you will see in the attached file, I want to list the results of a competition displaying the score from each round for each participant. The amount of participants each round varies so it needs to recognise if someone wasn't partaking in a specific round and just display a blank cell for that round. It also needs to be able to automatically sort whoever is in the lead as the competition proceeds. New participants might be added in the middle of the competition (only the seven best rounds count toward your total score), so it also needs to be able to fill in new names automatically.

I'm not the one who's going to be using this, so as much as possible should be automated. The only data I want to be required to enter manually is the player field and the amount of throws for each player, in each specific round. Everything else should be calculated automatically. Different amounts of points are awarded to the player based on the position in the round, so the winner will receive 100 points, the runner-up 92 points and so on. The points should be the data displayed in the total results, but the throws as well as the points are to be displayed in the table for each round. A participant might not finish one round, in which case a DNF should be entered and no points should be awarded for that round.

To be perfectly clear, the points showed in the attachment on the 2013 – Total sheet don't correspond to the score in the Round 1–5 sheet, I just entered a bunch of numbers to highlight how I basically want it to look. And, of course, the order of the players for each round will correspond to their score, so the winner will be displayed at the top and so on. The two other sheets, Round 6–10 and Ronud 11–15 (spelling error in the worksheet ) should look the same as Round 1–5.


Hopefully I got my point through, and I realise that I need help with quite a few things, so I'm very grateful if you help me with even one of my problems!

Test.xlsm