View Single Post
  #1   Report Post  
claytorm
 
Posts: n/a
Default Using TRIMEAN on a filtered list


Hi,

I want to apply TRIMEAN to a filtered data set. TRIMEAN ignores a set
percentage of outliers. I am currently using AVERAGE embedded in
SUBTOTAL, but there is no option to embed TRIMEAN within SUBTOTAL. Any
suggestions on how I could find a solution to this?

Bertie


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=398108