TM...please excuse my interjection..

Driller....please allow me to offer you some posting suggestions.
You're demonstrating pattern of challenging every post that interests you...
Even the responses that don't work. It's usually worth the effort to figure
out why certain methods work or don't work for yourself. Many times the
answers you are looking for are prominent in the Excel Help files. While I
applaud your enthusiasm, you certainly don't want to develop a reputation for
hijacking topics from the people who originally posted the questions. Also,
please bear in mind that the people who post responses are merely guides, not
slaves. Our goal is to head you in the right direction, not to do your work
for you.

***********
Regards,
Ron

XL2002, WinXP


"driller" wrote:

excuse mama, just want to learn here...
from formula
=AVERAGE(IF((A1:A6<MAX(A1:A6))*(A1:A6<MIN(A1:A6) ),A1:A6))
it works perfect yet,,
when i type
on A1:A6 ...1,1,3,leave as blank,3,6,6
the result is 2..
pls. clarify..

"Teethless mama" wrote:

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

ctrl+shift+enter (not just enter)


"frosterrj" wrote:

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