Forum Discussion
Excel 2016 Formula - skins
The skins are now calculating correctly. My last task is to count the total skins and place them in column P row 4. For example, there are 3 skins highlighted as wins. Can you help me with the formula to put the 3 wins in column P row 4.
Thanks so much for your help.
I'd do that with helper row - add formula as
=SUMPRODUCT(($C6:$C15="y")*(F6:F15=MINIFS(F$6:F$15,$C$6:$C$15,"y"))*(COUNTIFS($C$6:$C$15,"y",F$6:F$15,F6:F15)=1))
in that row, column by column, and sum to P3.
In attached above formula is in F5:N5
SergeiBaklan WOW, thank you both for posting those spreadsheets for golfing scoring and identifying skins. I’ve been looking for something like this to use at our club (nine hole golf club) for awhile now and I just arrive here my searching the internet. I would like to know a little bit more about the different tabs in the sample spreadsheet and how they are used. Can someone explain the use of the tabs and where you would enter scoring? I’m looking specifically to use this at our league nights. We often play a 2 person scramble so I would need to add a second column for a 2nd name and possibly even a 3rd and 4th column because we sometimes play a 3 and 4 person scramble. I’m hoping by adding additional name columns it won’t change any of the formulas going on in the spreadsheet. It would be nice as well if I could run some sort of macro that would automatically sort from the lowest total score shot to the highest score and keep all the other data in the same row together (names, scores on each holes and totals all stay together from lowest to highest score shot) and places them in ascending order. As an added bonus it would be really nice if the macro could also take into consideration progression scoring from the last hole #9 to hole #1 (in our case) when ties on holes are found with the same total score when sorting from lowest to highest score. To explain this, if three teams finish with the same score, the macro would look first at hole #9 and look for the lowest score. If two teams score a 3 and one a 4, the 4 would make that team be in 3rd place. The other two teams that are tied on hole 9, would go back to hole #8 to see what both their scores were on that hole….. you continue working your way back towards hole #1 until one team has score a lower score on a certain hole to determine who finished in first place. Is there a way to accomplish this with this sample spreadsheet? You can email me at mailto:email address removed for privacy reasons directly if you have any questions. THANKS.
We may add to helper row (#5) calculation of player on which position won
=IFNA(MATCH(1,INDEX(($C6:$C15="y")*(F6:F15=MINIFS(F$6:F$15,$C$6:$C$15,"y"))*(COUNTIFS($C$6:$C$15,"y",F$6:F$15,F6:F15)=1),0),0),0)
after that calculate total wins for each player as
=SUMPRODUCT(--($F$5:$N$5=(ROW()-ROW($E$5))))
My requirements for the skins game has changed once again. I need to total the number of skins game won by each player. I am attaching the Example spreadsheet. Can you help me with the formula that would take each player and total their wins. Player 1 has won no skins game so his #Won by Player Column ), Row 6 is 0. Player 3 has won 3 games (as highlighted) his total in Column O Row 8 is 3.
