My neighbor has been retired and golfing like crazy. He has recorded the round number, date, golf course, number of putts, and total score for each round in Excel. After almost three years and over 300 rounds of data, he wants to calculate the average scores for each golf course over the last three years. What Excel tools will help us do this? What other Excel tool can be used to produce the same result? How can we view only the rounds where he has greater than 32 putts per round? We also want to calculate a running average. How would we write that formula?
Bookmarks