January 7, 2012
I have a list of values and need to find the max, min, and average, which is all very straightforward, but I need to do the same after removing a variable % of values.
To explain, I may need to remove the top and bottom 10 or 20% to remove the outliers and then return the max, min and average of what is left.
The average can be achieved using Trimmean but I don't know how to get the max or min.
Any suggestions welcome
July 16, 2010
What version of Excel do you have? If you have Microsoft 365 you could use the FILTER function to extract the values > and < specified percentages (you'd have to calculate the limits) and then wrap it in MIN or MAX.