Hi everybody!
I am new to the group and have a strange obsession with creating spreadsheets. call me mad!
I was wondering if anyone can point me in the right direction. What I want to be able to do is take a race results from a website, this will already have everyone in the correct position for the race, I would want to copy and paste that into a spreadsheet. From here I would like the results populate a leaderboard so for example "Roger" would be 1st, he would get 10 points and Race 1 would show "Roger" with 10 points on the leaderboard. 1st race is easy I can do that. The next race I would need to do the same thing and "Roger may place 4th so would get 6 points, I would then need the leaderboard to show Roger with 16 points after race 2. I believe I could do this also. The issue I have is that the racers change on a weekly basis. So I dont have say 20 Racers which will be the same each week. I could have 50 racers but only the top 10 would be receiving points. Would it be possible to automate this so add points for each individual racer?
Thanks for your help
Bookmarks