View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
one way:
=(SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2})))/(COUNTA(A1:A100)-2)

--
Regards
Frank Kabel
Frankfurt, Germany

"nightlynik" schrieb im
Newsbeitrag ...
Please explain this so that I can understand!