title: INDEX, Match combination
body: <p>I have come across this formula which works in my application but I do not understand how it works
  <code>:=INDEX(MAX(($B:$B&lt;&gt;"")*(ROW(B:B))),0)</code></p>
  
  <p>I have broken it down and found that: </p>
  
  <p><code>=MAX($B:$B&lt;&gt;"") returns 1</code> regardless of what is the highest value in column B</p>
  
  <pre><code>=ROW(B:B) returns 1 
  </code></pre>
  
  <p>if I <code>input =MAX(($B:$B&lt;&gt;"")*(ROW(B:B)))</code> as an array formula it returns the row number of the highest non blank cell.</p>
  
  <p>However the INDEX formula does not seen to require an array formula input?</p>
  
  <p>Can anyone please explain?</p>