Dropping a Score
 

Thank you, but I need it to drop every seventh largest number, and then
average the group without that number included. Once it drops the number it
needs to beable to bring the number back if it is not the biggest number
after future score are entered. I with I could attach the document. Thank
you for your idea.

"Gary''s Student" wrote:

If you have a list of numbers (of any amount) and want to calculate the
averge, but not include that highest score, then:

=(SUM(A1:A100)-MAX(A1:A100))/99

change the 100 and the 99 to suit your case.
--
Gary''s Student - gsnu200776


"Christi" wrote:

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?

Dropping a Score
 

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