Prev: Combining Cells
Next: Can I use Sumproduct with the LEFT Function?
From: Brad Autry on 12 Apr 2010 13:16
I'd like to use the PERCENTILE function in a list that has been autofiltered
and get the results based only on the visible cells.

I've used SUBTOTAL in order to get count, average, min and max. But I need
to get the .25 and .75 percentile figures for the filtered data (visible
cells only).

I've scoured these forums. I've scoured the web. I've found some vba code
that was supposed to select only visible cells but it doesn't work for me. I
posted last week in the programming section of these forums (and again this
morning) but got no reply. I figured I'd try here. I'm at my wits end.
Please help me!

Many thanks in advance!!

Brad
From: T. Valko on 13 Apr 2010 00:36
>a list that has been autofiltered

Let's assume this is your unfiltered data:

76
45
64
85

Show me the formula you'd use to get the result you want and tell me what
that result is.

Now, let's assume the filter is applied and this is your visible data:

76
45

What result would you expect?

--
Biff
Microsoft Excel MVP


"Brad Autry" <BradAutry(a)discussions.microsoft.com> wrote in message
news:FC1BB104-DB45-4BF7-88CF-23DF4F59106A(a)microsoft.com...
> I'd like to use the PERCENTILE function in a list that has been
> autofiltered
> and get the results based only on the visible cells.
>
> I've used SUBTOTAL in order to get count, average, min and max. But I
> need
> to get the .25 and .75 percentile figures for the filtered data (visible
> cells only).
>
> I've scoured these forums. I've scoured the web. I've found some vba
> code
> that was supposed to select only visible cells but it doesn't work for me.
> I
> posted last week in the programming section of these forums (and again
> this
> morning) but got no reply. I figured I'd try here. I'm at my wits end.
> Please help me!
>
> Many thanks in advance!!
>
> Brad


 | 
Pages: 1
Prev: Combining Cells
Next: Can I use Sumproduct with the LEFT Function?