title: How do I find the last non-blank non-zero positive value in a column/range?
body: <p>I have a column, let's say column A, which contains a list of numbers, which can be positive or negative. Those numbers are then followed by a varying number of blanks (i.e. =IF(some_condition_is_met,"",value). I want to find the last non-blank non-zero positive value in that column.</p>
  
  <p>E.g.</p>
  
  <pre><code>    Column A
      0.00
      0.00        
      0.00
      0.00
      15.00
      -5.00
      0.00
      blank
      blank
      blank
  </code></pre>
  
  <p>I want the formula to ignore the blanks, and the zeros, and the negative values, and return 15.00 in this case.</p>
  
  <p>I would prefer not to use an array formula, if possible.</p>
  
  <p>The other solutions I've seen are less sophisticated, e.g. they only find the last non-zero or non-blank value. </p>
  
  <p>I can't figure this one out!</p>