Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignoring hidden rows in PERCENTILE function
Hello,
I'm trying to summarize results of autofiltered content. I've used the subtotal function to provide average, min, max, and count - but I also need to provide 25th and 75th percentile values, which can not be calculated with subtotal. So, I need to use the =PERCENTILE function but only apply it to visible cells. I'm not good enough with vba to write something to make this happen. :\ If you can help and have the time, I'd be grateful. Thanks! Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group function with hidden rows | Excel Programming | |||
Problem using group function with hidden rows | Excel Programming | |||
Ignore Hidden Rows on Sum Function on Excel XP | Excel Discussion (Misc queries) | |||
Sum function which ignores hidden rows | Excel Worksheet Functions | |||
Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) |