J
johnflem
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
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