Can I do this??

S

Skip

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
 
D

Dave Peterson

One way:
=TRIMMEAN(A1:A11,4/11)
or
=(sum(a1:a11)-sum(large(a1:a11,{1,2}))-sum(small(a1:a11,{1,2})))/7
 
D

Dana DeLouis

I would like to throw out the two highest,
the two lowest, and get an average...
Click to expand...

Hi. I like to think of it as throwing out '4 of the '11 numbers...

=TRIMMEAN(A1:A11,4/11)
 
Top