All
This is a new thread. I have the below spreadsheet where the scores are calculated for each golfer. How do i "combine" a pair of golfers so that the total net is calculated? So for each pair of golfers, between the two, i would take the lowest score (MIN function) between the two and use that for each hole (18 holes of golf)
So i already have the scores for each person listed below in the table. I want to pull just each person's "NET" however for a pair, i need to take the lowest score per hole between each pair. For example on the below with John Doe and James smith, the lowest score on hole 1 is "2" (James).
If i have John and TOny as a pair, the low score say on hole 13 would be a "2" (John).
So i want to see if a formula can be created so that the second table below is filled in with the total combined score. The combined score is the sum of each MIN score for the pair for 18 holes then come up with a total.
So say the combined total for John and Tony would be 68 . That would then be filled in the second "grid" table below (Cell C4)
This is a new thread. I have the below spreadsheet where the scores are calculated for each golfer. How do i "combine" a pair of golfers so that the total net is calculated? So for each pair of golfers, between the two, i would take the lowest score (MIN function) between the two and use that for each hole (18 holes of golf)
So i already have the scores for each person listed below in the table. I want to pull just each person's "NET" however for a pair, i need to take the lowest score per hole between each pair. For example on the below with John Doe and James smith, the lowest score on hole 1 is "2" (James).
If i have John and TOny as a pair, the low score say on hole 13 would be a "2" (John).
So i want to see if a formula can be created so that the second table below is filled in with the total combined score. The combined score is the sum of each MIN score for the pair for 18 holes then come up with a total.
So say the combined total for John and Tony would be 68 . That would then be filled in the second "grid" table below (Cell C4)
John Doe | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 4 | 5 | 5 | 5 | 6 | 84 | |
John Doe Net | 4 | 4 | 3 | 3 | 3 | 5 | 4 | 5 | 5 | 8 | 4 | 3 | 2 | 3 | 4 | 5 | 5 | 6 | 8 | 76 |
James Smith | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 4 | 5 | 5 | 5 | 6 | 84 | |
James Smith Net | 2 | 2 | 2 | 2 | 1 | 3 | 2 | 3 | 3 | 6 | 2 | 1 | 0 | 2 | 3 | 3 | 3 | 4 | 40 | 44 |
Tony Jones | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 6 | 4 | 5 | 5 | 5 | 6 | 87 | |
Tony Jones Net | 3 | 4 | 3 | 3 | 2 | 5 | 3 | 4 | 4 | 8 | 4 | 3 | 5 | 3 | 4 | 4 | 4 | 5 | 16 | 71 |
Dave Johnson | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 3 | 5 | 5 | 5 | 6 | 83 | |
Dave Johnson Net | 3 | 4 | 3 | 3 | 2 | 5 | 3 | 4 | 4 | 8 | 4 | 3 | 2 | 2 | 4 | 5 | 5 | 6 | 13 | 70 |
Column A | James Smith | John Doe | Tony Jones | Dave Johnson |
James Smith | (would be blank) | |||
John Doe | blocked | |||
Tony Jones | Blocked | |||
Dave Johnson | Blocked |