madchemist
Board Regular
- Joined
- Jul 10, 2006
- Messages
- 198
I have a spreadsheet I am using to calculate golf handicaps. Columns B through Y contain the weekly scores for each player. Not everyone plays each week so there will be blank cells, but what I am trying to do is average the 8 most recent scores, so essentially start at Column Y for each player and come up with the average score of their last 8 rounds. So for some players it might be 8 cells immediately preceding (and including) column Y. Others might have missed weeks so it needs to go back further until it finds 8 cells with values in them.
Anyone have any ideas how I can accomplish this? Ideally I'd want to average the last 8 scores in column Z.
Anyone have any ideas how I can accomplish this? Ideally I'd want to average the last 8 scores in column Z.