Morning All,

I am trying to remove some outliers from a large amount of data, currently i am using the TRIMMEAN function and it seems to be working okay.

jus out of interest is there an alternative way to change the percentage of outliers that are removed.

With the TRIMMEAN is will take say 10% off the top and bottom, but i was wondering if you can take say 10% off the top and 30% off the bottom.

Any help is greatly appreciated.

kind regards