title: Excel 2016: How to find out the row number of a max value?
body: <p>I'd like to find out the row number of the max value. Give example below:</p>
  
  <pre><code>100
  101
  102
  103
  104
  105
  =MAX(C3:C8)
  105
  </code></pre>
  
  <p>I need to know the ROW number of the MAX value which is 105 here. If I place 100 at A1 then my desired output should be <strong>6</strong>.</p>
  
  <p>Excel doesn't allow me to use:</p>
  
  <pre><code>    =ROW(MAX(A1:A6))
  </code></pre>
  
  <p>Any help will be appreciated. </p>