title: Using MATCH function without blank cells
body: <p>My excel sheet is as below</p>
  
  <p><img src="https://i.stack.imgur.com/fRwjN.png" alt="enter image description here"></p>
  
  <p>When I use the following formula the result is <strong>8</strong> </p>
  
  <pre><code>=MATCH(5;B8:AS8;0)
  </code></pre>
  
  <p>I would like to expand this formula; not adding blank cells to range (<code>B8:AS8</code>).</p>
  
  <p>I mean if I don't add blank cells to range result will be <strong>3</strong></p>
  
  <p>Which function must I use to expand my formula? </p>