Percentile on filtered range
 

I have a large dataset, but I want to look at percentiles by fitlered data
For example, Range column I has 4 values, A,B,C,D
I want to get the 50th percentile of just the A's, then 50th of just the B's
etc.
In a VBA function is set the range's autofilter field and criteria, but when
I do a worksheet.percentile on the range, it always returns the percentile
for the whole dataset, not just the fitlered A's etc.
Any way to do this short of creating a separate worksheet for each range
group?
Thanks

Percentile on filtered range
 

Some formulas by Aladin Akyurek over at mrexcel.com can most probably be
changed to suit your needs. They're he
http://www.mrexcel.com/forum/showthr... r#post796892


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"johnflem" wrote:

I have a large dataset, but I want to look at percentiles by fitlered data
For example, Range column I has 4 values, A,B,C,D
I want to get the 50th percentile of just the A's, then 50th of just the B's
etc.
In a VBA function is set the range's autofilter field and criteria, but when
I do a worksheet.percentile on the range, it always returns the percentile
for the whole dataset, not just the fitlered A's etc.
Any way to do this short of creating a separate worksheet for each range
group?
Thanks