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
|