I'm not Excel savvy, but I'm trying to create average(s) for golf,
the golfers largest score every seven rounds is dropped and then
the remaining scores are averaged. How do I do this? I've tried
with no success, the formula I've enter is =Average (A5:A10) and
then I have the next column set up for the dropped score so in B11
I have the formula =Large(A5:A46, 1) and this formula is placed
every 7 scores. HELP! Can it be done?

To get started, the csv file is an example that might work for you with
seven rounds. Column A has the scores. Column B has the max of each
round. The average is in C1.

--------------------- cut here ---------------------
Score,Drop,"=""Average=""&TEXT((SUM(A2:A50)-SUM(B2:B8))/42,""0.0"")"
95,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
98,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
82,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
96,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
82,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
100,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
92,"=MAX(OFFSET($A$1,7*(ROW()-2)+1,0,7,1))",
93,,
83,,
82,,
87,,
92,,
76,,
85,,
83,,
80
75
96
97
86
82
85
97
88
86
87
87
80
95
82
83
97
82
94
75
85
75
97
75
100
90
86
96
92
85
83
97
81
95