filters and quartile formula

R

rwilliam

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help in Median of a quartile 4
conditional format based on column statistics and loop over columns 1
QUARTILE Function on Sorted Data 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Why MS Excel produce diffrent result for the function "Quartile" 2
Slideshow with black border around it 0
Third Quartile 2

Top