I am trying to build a spreadsheet for a golf group and can not figure out how to get the lowest average of 4 of the last 6 scores. There are many breaks and some do not have 6 reported scores.
GolferName 5/7 5/14 5/21 5/28 6/4 6/11 6/18 6/25 7/2 7/9 7/16 7/23 7/30 8/6 8/13 8/20 8/27 9/3 9/10 9/17 Average Handicap Index Number Handicap
Lindquest, S 50 50 50 50 50 22.7 19
Noel, B 44 45 46 44 44 45 46 48 44.25 16.2 14
Bookmarks