I’m working on a golf betting game scorecard in excel. The problem is: I need to be able to keep 5 players score. For instance if two players win the hole, I need to highlight those two players and assign a value to the win. <o
></o>Example: One the first hole Cells C6 and C8 are the winners (thus highlighted) and they won the amount in C9. On hole 2, Cells C5, C6 and C7 are the winners but a different amount in C9. The question is how can I total the amount won after 18 holes per player? <o></o>There might be an easier way todo this so any help would be appreciated.
></o>Example: One the first hole Cells C6 and C8 are the winners (thus highlighted) and they won the amount in C9. On hole 2, Cells C5, C6 and C7 are the winners but a different amount in C9. The question is how can I total the amount won after 18 holes per player? <o></o>There might be an easier way todo this so any help would be appreciated.
