ExcelBanter - Can I do this??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I do this?? (https://www.excelbanter.com/excel-worksheet-functions/87310-can-i-do.html)

Skip

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

Dave Peterson

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

Dana DeLouis

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

Ragdyer

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

All times are GMT +1. The time now is 05:37 PM.