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?