I'm creating a spreadsheet for a golf league that my buddies and I are trying to put together. Players will be awarded points based upon their finish each week (similar to the FedEd Cup). Attached is what I have done so far. I have entered mock scores for round one for each player.
The "Results" worksheet is where I'm in need of help. At the bottom of the worksheet I have indicated the number of points that will be awarded to the given rank per week (1st=500, 2nd=300, ect.). In the event of a tie, I would like the point totals to be added together and divided among all golfers tied for a particular position at the end of a round. For example, there are two golfers tied for second. Their score would be an average of the 2nd and 3rd place scores (300+190=490/2=245).
Thank you for your help in advance! Let me know if you need more info.
Bookmarks