If the numbers are in cells A1:A10 (change as appropriate) then

=(SUM(A1:A10)-MAX(A1:A10)-MIN(A1:A10)/(COUNT(A1:A10)-2)

should do it (unless perhaps you have special rules about
what should happen if the min or max values occur more than
once).



On 15 Apr, 16:26, "Tom" wrote:
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