Thread: max and min
View Single Post
  #5   Report Post  
Niek Otten
 
Posts: n/a
Default

I assumed you meant the average. Now that I see the other answers I assume
I'm wrong.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Niek Otten" wrote in message
...
=(SUM(YourRange)-LARGE(YourRange,1)-LARGE(YourRange,2)-SMALL(YourRange,1)-SMALL(YourRange,2))/(COUNTA(YourRange)-4)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"touaki" wrote in message
...
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?