If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
visible cell only
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 |
#2
|
|||
|
|||
visible cell only
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|