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