I ran into a problem that must have a better answer than what I came up with.
We had a golf tournament last weekend and each player played two rounds of golf. We played Stableford so the bigger number is better. We had 10 players on each team.
We took the better score of each player between the two days for their team score. Which team won?
See the attached where I did a Pivot to show the Max of each players score but then wanted to sum the maximums. I ended up doing a running total to get the team scores.
There must be an easier/better way.
Bookmarks