| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filters and quartile formula
I am running in to an intermittant issue with a formula that I am using for
getting quartile results. I am filtering a 1 or 2, if I filter on 1 I get the results of all data, if I filter on 2 I get 0 as a result. Is there a problem with the formula or how I am setting the filter? Thanks for any help. following is the formula: =QUARTILE(IF(SUBTOTAL(2,OFFSET(A$9,ROW(A$9:A$126)-ROW(A$9),,1)),A$9:A$126),2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
| formula or filters | Excel Discussion (Misc queries) | |||
| Lookup to return count, median, lower quartile, upper quartile&ave | Excel Discussion (Misc queries) | |||
| What is the formula used to calculate the 1st and 3rd quartile? | Excel Worksheet Functions | |||
| Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Threaded Mode
