Average formula
 

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?

Average formula
 

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

will exclude min and max

replace A1:A5000 with your data range.

--


Regards,


Peo Sjoblom

"scott" wrote in message
...
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?

Average formula
 

for samples from A1 thru A100:

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

make the obvious adjustment for the dataset
--
Gary''s Student - gsnu200803


"scott" wrote:

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?

Average formula
 

To generalize this:

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

Regards
Fred

"Gary''s Student" wrote in message
...
for samples from A1 thru A100:

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

make the obvious adjustment for the dataset
--
Gary''s Student - gsnu200803


"scott" wrote:

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?