Quartile function using criteria

J

jonathan_voll

I am looking to use the quartile function in such as way as to choose
data point from a column based on a criteria located in an adjacent
column. This would be similar to a COUNTIF function in that only data
point meeting a certain criteria will be counted. Any thoughts?
Thanks,

Jon
 
B

Bernard Liengme

To find the first Q of set of numbers in H when corresponding G value is "a"
=QUARTILE(IF(G1:G7="a",H1:H7,""),1)
This is an array formula, so commit it with CTRL+SHIFT+ENTER (not just
ENTER)
best wishes
 

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
Limitations of Quartile Function 10
conditional format based on column statistics and loop over columns 1
Copying Portions of Data 0
Average within quartiles 3
Creating a Chart on form from selected data in query. 0
Page numbering with Merged Document and IF statements 1
Looking for Information Word (Office 365) editing using VB.Net 1

Top