AZgolfer59
New Member
- Joined
- Nov 17, 2014
- Messages
- 6
I have columns of golf scores (by person and date of round) varying from 1 score to 30 scores and constantly being added to. I need a formula at the bottom to average the lowest 10 scores from the most recent 20. Some columns have many blanks, some are very few. And if a column has less than 20 scores, it needs to average whatever is available. Thanks!