excuse me Bob Phillips, just want to learn here, i hope no blacklisting,
from formula
=AVERAGE(IF(((A1:A10<MAX(A1:A10))*(A1:A10<MIN(A1 :A10))),A1:A10))
from A1:A10 (10 cells non-blank all positive)
i type
1,1,3,3,3,3,3,3,6,6
the result is #VALUE!
please clarify...

"Bob Phillips" wrote:

=AVERAGE(IF(((A1:A10<MAX(A1:A10))*(A1:A10<MIN(A1 :A10))),A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"frosterrj" wrote in message
...
What would be the best way to use the avg() function (or any other
appropriate function) on a column or row while excluding the highest and
lowest value?

is this possible in one cell, or does it have to be split up using min()
and
max() somewhere to exclude the value?

Thanks,
Robert