Hi All,

I know the trimmean formula works by removing certain values from the bottom and top of a range.

What I need is a formula which only takes away from the top of the range. I have put an example below.

If the trimmean formula isnt capable of calculating is there an alternative solution

I want to average the bottom 90% of values.

1 Include
2 Include
5 Include
6 Include
8 Exclude
2 Include
3 Include
4 Include
2 Include
1 Include