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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |