Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I do this??
Excel 2003.
I have a column of 11 numbers. I would like to throw out the two highest, the two lowest, and get an average of the remaining 7. Any help is greatly appreciated. Thanks Skip |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I do this??
One way:
=TRIMMEAN(A1:A11,4/11) or =(sum(a1:a11)-sum(large(a1:a11,{1,2}))-sum(small(a1:a11,{1,2})))/7 Skip wrote: Excel 2003. I have a column of 11 numbers. I would like to throw out the two highest, the two lowest, and get an average of the remaining 7. Any help is greatly appreciated. Thanks Skip -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I do this??
I would like to throw out the two highest,
the two lowest, and get an average... Hi. I like to think of it as throwing out '4 of the '11 numbers... =TRIMMEAN(A1:A11,4/11) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Skip" wrote in message oups.com... Excel 2003. I have a column of 11 numbers. I would like to throw out the two highest, the two lowest, and get an average of the remaining 7. Any help is greatly appreciated. Thanks Skip |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I do this??
One way:
=AVERAGE(LARGE(C1:C11,{3,4,5,6,7,8,9})) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Skip" wrote in message oups.com... Excel 2003. I have a column of 11 numbers. I would like to throw out the two highest, the two lowest, and get an average of the remaining 7. Any help is greatly appreciated. Thanks Skip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|