title: Excel MATCH + COUNTIF function: retrieving the nth value in an array
body: <p>I have a formula that I'm using in Excel to return the row # of the first item that matches a specified value.</p>
  
  <p>Formula: <code>=MATCH(0,COUNTIF($B$1,List),0)</code> + <kbd>CTRL</kbd> + <kbd>SHIFT</kbd> + <kbd>ENTER</kbd> and in Mac: <kbd>CMD</kbd> + <kbd>RETURN</kbd></p>
  
  <p>Becomes: </p>
  
  <pre><code>MATCH(0,{**0**;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0},0)
  </code></pre>
  
  <p>Outputs: 1</p>
  
  <p>I would like to update the function so that I can find the 2nd, 3rd, etc. instance that matches the specified value.</p>
  
  <p>Like This: </p>
  
  <pre><code>MATCH(0,{0;**0**;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0},0)
  </code></pre>
  
  <p>And this outputs: 2</p>