Trimmean formula or alternative

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

HI Jetemc

Sorry I should of said at the outset, I am using excel 2003 unfortunately that doesnt contain the Rank.EQ formula.

Do you know of another way around this?

Thanks for your time looking into this

Hi Jetemc sorry I was mistaken we are using excel 2007