Obtaining a value above a certain percentage 1

[Trackfiend]

Here's the setup. I have a range of data that I would like to obtain the value above the minimum 10% of the varying range value.

Column
2
4
2
8
10
31
12

I am trying to eliminate the bottom 10% of values and get the next value up from this. Any suggestions?

 

[IRstuff]

How is this different than your other problem with the >0 constraint replaced with >(0.1*(max(range)-min(range)))

TTFN

FAQ731-376

 

[Trackfiend]

Your right. Before I simply obtained a 10% value of my max and then used the >0 constraint with the value. It was a two step process. Your formula cleaned that up for me. Thank you.