Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
value of first visible cell | Excel Worksheet Functions | |||
Visible text in a cell | New Users to Excel | |||
how can i do a (fx) visible in a cell | Excel Worksheet Functions | |||
Not all of the text is visible when looking at the cell. | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |