Average formula

S

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?
 
P

Peo Sjoblom

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

will exclude min and max

replace A1:A5000 with your data range.

--


Regards,


Peo Sjoblom
 
G

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
 
F

Fred Smith

To generalize this:

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

Regards
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top