title: Excel MAXIF function or emulation?
body: <p>I have a moderately sized dataset in <a href="/questions/tagged/excel" class="post-tag" title="show questions tagged &#39;excel&#39;" rel="tag">excel</a> from which I wish to extract the maximum value of the values in Column B, but those that correspond only to cells in Column A that satisfy certain criteria. </p>
  
  <p>The desired functionality is similar to that of <code>SUMIF</code> or <code>COUNTIF</code>, but neither of those return data that is necessary. There isn't a <code>MAXIF</code> function; how do I emulate one?</p>