Hi
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
GreenBoy.
Hi Dave,
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.
Mynda
Hi Mynda - thank you for the response
I am using 365 - and have never used FILTER before... I will take a look into this but it does look as if its going to be very helpful
Thanks again
Dave
