title: Finding the row number of last row in column with a specific value in excel
body: <p>So I have a column with values, and I am looking for the highest/latest row number with a specific value.
  An example:</p>
  
  <p><a href="https://i.stack.imgur.com/PHZOo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PHZOo.png" alt="enter image description here"></a></p>
  
  <p>In this case, I want a function that when searching for the last row number, within the value range, containing 0, it would return 8.</p>
  
  <p>Another option is to get the index of the first empty cell and subtract 1.</p>
  
  <p>Thanks</p>