Thank you, Andrew, Dana, and Jialiang. The suggestions are very helpful.

"Tom" wrote in message
...
Greeting,

I have a list of integer value, and am wondering how to get the average of
the list but discarding the min and max from the list.For example:
list:
11
3
3
1
Average:
3
because (3 + 3) / 2 = 3

I don't want use macro. Can it be achieved in one Excel formula?

Thanks
Tom