title: Jump to the next non-empty cell and use lates value in the list
body: <p>I have the following Excel spreadsheet:</p>
  
  <pre><code>        A                      B                    Desired Result Column B
  1    Product A                50                     **50**       **50**         
  2    Product B        =IF(A2="","",B1)                 50           50  
  3                     =IF(A3="","",B2)              
  4    Prodcut C        =IF(A4="","",B3)                 50         **40**
  5                     =IF(A5="","",B4)
  6    =""              =IF(A5="","",B5)
  7    Product D        =IF(A5="","",B6)                 50           40
  8    Product E        =IF(A5="","",B7)                 50           40
  </code></pre>
  
  <p>** Input of User</p>
  
  <p>In <strong>Column A</strong> there is a list of different products. As you can see there can either be <code>empty cells</code> or cells with formula <code>=""</code>.</p>
  
  <p>In <strong>Column B</strong> I want to achieve that the last value before the first <code>empty cell</code> or <code>=""</code> cell applies to the other rows.</p>
  
  <p>For example: If I enter a <em>50</em> in <strong>Cell B1</strong> I want to achieve that this <em>50</em> appears next to every product and <code>empty cells</code> or <code>=""</code> are ignored.</p>
  
  <p>I can achieve this with the following formula:</p>
  
  <pre><code>=IF(A2="","",$B$1)
  </code></pre>
  
  <p>Now the problem is, that the user can also type a different number in another cell in <strong>Column B</strong>. For example he could type in a <em>40</em> in <strong>Cell B4</strong>.</p>
  
  <p>In this case I want that the <em>40</em> applies to all other following rows instead of the 50 as you can see in the section "<strong>Desired Result Column B</strong>" in the example above.</p>
  
  <p>How do I have to change my formula in <strong>Column B</strong> to achieve this?</p>