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

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