title: Excel formula with named range
body: <p>I have a question about formulas, it´s not an easy one, I hope someone can solve it.</p>
  
  <p>Table looks like this</p>
  
  <pre><code>Idx Val Rslt
  1   1   3
  1   2   3
  1   3   3
  2   11  13
  2   12  13
  2   13  13
  </code></pre>
  
  <p>Named range NR encapsulates columns Idx and Val (without headers).</p>
  
  <p>I would like to have a formula for Rslt column cells that :</p>
  
  <p>a) recognizes rows with same Idx value</p>
  
  <p>b) returns max Val from that set of rows</p>
  
  <p>I hope I was clear, if not - feel free to ask.</p>
  
  <p>Thanks</p>