Average formula

[scott]

Is there a manipulation to the "average" function that allows a user to take
the average of a set of data and exclude the maximum and minimum value of the
entire set? I am using a LARGE set of data and I do not want to have to sort
data from min to max ,if I can avoid it.

Thanks for the help.

If such a manipulation in Excel is available, does it work for other
functions?

 

[Peo Sjoblom]

=TRIMMEAN(A1:A5000,2/COUNT(A1:A5000))

will exclude min and max

replace A1:A5000 with your data range.

--


Regards,


Peo Sjoblom

 

[Gary''s Student]

for samples from A1 thru A100:

=(SUM(A1:A100)-MAX(A1:A100)-MIN(A1:A100))/98

make the obvious adjustment for the dataset

 

[Fred Smith]

To generalize this:

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

Regards
Fred