Quartile function using criteria

  • Thread starter Thread starter jonathan_voll
  • Start date Start date
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
 
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
 
Back
Top