Hi, don't know if anyone here can help with this..but!
Basically my housemate is president of the ten pin bowling club at uni and he wants to make a spreadsheet to calculate scores.
It will work as an F1 style league table, best score on the day gets 10, 2nd gets 9 etc down to 0. Each player has a handicap so what basically needs to happen is this:
He has a column with each persons handicap, he has a column of the weeks score, He wants to be able to type each persons score into the correct box, and then have excel add the handicap to that score, find the 10 highest scores and allocate the appropriate points to another column.
Is this possible? If so could someone by any chance write out the forumula for that? *angelic face*
Cheers
Chris.


LinkBack URL
About LinkBacks
Reply With Quote