title: Excel - find last value in a column which is not an error or blank
body: <p>I need to find in a column of an excel spreadsheet the last non-error, non-blank value. The column can have several instaces of #N/A which are alternating with actual values. There are several solutions for finding the last non-empty cell, but the solutions do not consider errors, in particular if the last non-empty cell has got an error. </p>
  
  <p>The solution would be 3 in this case. </p>
  
  <p><img src="https://i.stack.imgur.com/o8RpC.jpg" alt="enter image description here"></p>