Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY chart not dropping off to 0, when there is not value | Charts and Charting in Excel | |||
Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
Dropping Zeros | Excel Worksheet Functions | |||
Dropping 0 | Excel Discussion (Misc queries) | |||
Dropping the lowest score from a gradebook | Excel Worksheet Functions |