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