I run a golf Society and each week we all put a pound in the pot and the highest score or scores as there can be more that one gets the bulk of the prize second place receives a £5 and we put £5 aside for the Xmas bash
What I would like is :
Column A = Persons, column B=Score, Column C= points, Column D = top player, Column E= top Points, Column F =top money.
( if there are two with the same score then the 10points and the 8 points are added and shared between them obviously if there are 3 then the top three scores are shared between them in that instance 4th place would receive 6points but again if there are ties for that, 4th and 5th and so on would be shared so it could end with four people sharing 1 point at the bottom thus getting 0.25points
Points are 10 8 7 6 5 4 3 2 1 so no 9 ( we have 40 players in the society)
I suspect I will need a macro so that I just need to put the score in column B each week and C, D, E, F will change accordingly
Tough ask I know
Bookmarks