title: Possible to use QUARTILE function over a conditional range in Excel?
body: <p>I am looking for something that works like a <code>quartileif</code> function (if one existed), but am not sure how to simulate it. There's a table column I want to take the 3rd quartile of, but only if it's within a certain year. Is there a way I could do this in one formula or do I need to just resort to creating multiple tables (which gets messy)?</p>
  
  <p>Thanks.</p>