title: Excel formula to fill cell below with cell above until value changes
body: <p>if <code>A</code> is a column in an excel spreadsheet, I would like to fill the blank cells in the subsequent rows of <code>A</code> with the value of the last cell above it that had one.  Once the column has a another cell with a value, use the value, and so on. <a href="http://www.excelbanter.com/showpost.php?s=ff33990675ceb0330acaf83a9c1e0b15&amp;p=650500&amp;postcount=2" rel="nofollow">This</a> works, using Go To Special > Blanks > <code>=</code> <code>up arrow</code> > ctrl enter.  Is there a way to do this with a formula?  Thanks.  </p>
  
  <p><code>A</code> <code>…</code> <code>A</code></p>
  
  <p><code>1</code> <code>…</code> <code>1</code></p>
  
  <p><code>_</code> <code>…</code> <code>1</code></p>
  
  <p><code>_</code> <code>…</code> <code>1</code></p>
  
  <p><code>2</code> <code>…</code> <code>2</code></p>
  
  <p><code>_</code> <code>…</code> <code>2</code></p>
  
  <p><code>_</code> <code>…</code> <code>2</code></p>
  
  <p><code>_</code> <code>…</code> <code>2</code></p>
  
  <p><code>3</code> <code>…</code> <code>3</code></p>
  
  <p><code>_</code> <code>…</code> <code>3</code></p>
  
  <p><code>etc</code> <code>…</code> <code>etc</code></p>