visible cell only


B

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
 
Ad

Advertisements

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top