2013 Golf Trip (1).xls
Hey guys. First off thank you to all the people on the forum who have helped me put this together. Right now my next hurdle is a way to calculate pay outs. Only problem is I have having a hard time figuring out how to handle multiple scores that are the same. Basically i need to set the program to evaluate the scores and assign a pay out value based on a set amount. But if scores are duplicate, say 3 people shot 36 on the front, i need it to take 1st through 3rd payouts, add them together, then divide it among the 3, then continue with 4th place and on. The second issue is trying to figure out how to handle if there are 10 people who all together only have 5 different scores among them. I would like to use the columns just to the right of the rankings to display the pay outs. for simplicity just use 50, 40, 30 ,20, and 10 for the payouts. I know this may be too much and if it can't be done simply then i wont worry about it and will do it by hand.
Bookmarks