Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MEDIAN(IF((A1:A100SMALL(A1:A100,2))*(A1:A100<LAR GE(A1:A100,2)),A1:A10
0))

Note: This does not work if you have ties in the two smallest/largest
values

--
Regards
Frank Kabel
Frankfurt, Germany

"touaki" schrieb im Newsbeitrag
...
I want that someone tell me how do I write the formula to do this:
From a
range of numbers in a colunm, I pretend to calculate de MEDIA,
excluding the
two big and the two smaller numbers. Is it possible?