Just figured out how to do the Median using an array formula -
{=MEDIAN(IF(AM8:AM12AM24,AM8:AM12))} but can't figure out how to do
percentile using an array formula, can anyone help?
Cheers

"Rehanna" wrote:

I need a formula (or other solution) that will pick out certain data in a
data set that is a particular value, and then calculate the median, 90th
and 10th percentile of this data. the only way i have been able to do it so
far is physically seperate the data, however this is tedious and
time-wasting, any tips/suggestions would be appreciated.
Cheers
e.g
Data Set
5
1
9
.05
15
And i only want to process data 4