DowningAir
New Member
- Joined
- Apr 4, 2011
- Messages
- 4
Hi everyone. I'm new to the forum and I've been reading some of the older posts, teaching myself as I go. The information has been very helpful. Thank you for the resource!
That being said, I'm putting together a spreadsheet for golf skins and I want to calculate the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). This is what I have so far...
A21=IF(D21=1,INDEX(A7:A18,MATCH(D21,B7:B18,0)),"Tie") (Inserts the player's name if only 1 low score is recorded and inserts "Tie" if more than 1 low score is recorded)
B21=Hole Number (1 through 18 for cells B21:B38)
C21=MIN(B7:B18) (Finds the low number in the scorecard columns per hole (B=Hole 1))
D21=COUNTIF(B7:B18,C21) (Returns the total of minimum numbers in Column C)
These cells extend from 21:38 for all 18 holes. Like I said, I'd like column E to represent the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). 12 players, $5/player/round, so the theoretical pot per hole would be (60/18). Any help would be appreciated. I'm a novice when it comes to excel so if my explanation is unclear please feel free to ask questions. Thank you in advance!
That being said, I'm putting together a spreadsheet for golf skins and I want to calculate the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). This is what I have so far...
A21=IF(D21=1,INDEX(A7:A18,MATCH(D21,B7:B18,0)),"Tie") (Inserts the player's name if only 1 low score is recorded and inserts "Tie" if more than 1 low score is recorded)
B21=Hole Number (1 through 18 for cells B21:B38)
C21=MIN(B7:B18) (Finds the low number in the scorecard columns per hole (B=Hole 1))
D21=COUNTIF(B7:B18,C21) (Returns the total of minimum numbers in Column C)
These cells extend from 21:38 for all 18 holes. Like I said, I'd like column E to represent the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). 12 players, $5/player/round, so the theoretical pot per hole would be (60/18). Any help would be appreciated. I'm a novice when it comes to excel so if my explanation is unclear please feel free to ask questions. Thank you in advance!