visible cell only

[Brad Autry]

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

 

[T. Valko]

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?