FIND AVERAGE OF VALUES EXCLUDING MAX AND MIN VALUE

August 17th 2012

Formula in A13:

=(SUM(A1:A12)-MIN(A1:A12)-MAX(A1:A12))/(COUNT(A1:A12)-2)

This post first appeared on Excel VBA Tips, please read the originial post: here

People also like

Share the post