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)