View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Average (exclude 1 min & 1 max Value)

one way:
=(sum(d5:r5)-min(d5:r5)-max(d5:r5)))/(count(d5:r5)-2)

another:
=TRIMMEAN(d5:r5,(COUNT(d5:r5)-2)/COUNT(d5:r5))

Ken wrote:

Excel2003 ...

Range D5:R5 contains positive numbers (not sorted) & some numbers may repeat.

I wish to AVG range (exclude 1 Min & 1 Max Value) ... In the list below I
wish to AVG (exclude 1 min value ( 24 ) & 1 max value ( 55 ).

25-26-42-53-24-32-45-35-43-24-55-43-24-55-43-43-45-46-36-34

Thanks ... Kha


--

Dave Peterson