title: Find first non-blank cell in a range
body: <p>I am working with a list of data where one or multiple cells in a row can be blank.  </p>
  
  <p>Lets say the list is cells <code>A1</code>, <code>A2</code>, <code>A3</code>, <code>A4</code>.   I am trying to create a function that will do the following:</p>
  
  <pre><code>IF A1 has a value I want the cell to return A1.
    IF A1 is empty then I want it to return A2.
     IF A1 and A2 are both empty I want it to return A3.
      If A1, A2 and A3 are all empty I want it to return A4.    
  </code></pre>