title: Excel copy cell value from above only if the current cell is blank
body: <p>I am wanting to the value of the above cell to the curernt cell below it, ONLY if current cell is empty.  I need this to be dynamic for all cells in a column.</p>
  
  <p>So my Excel file looks like this:</p>
  
  <pre><code>1 | Person
  2 |
  3 | Record
  4 | 
  5 | Tiger
  6 | 
  7 | 
  8 | Scott
  9 |
  </code></pre>
  
  <p>And I want it to look like this:</p>
  
  <pre><code>1 | Person
  2 | Person
  3 | Record
  4 | Record
  5 | Tiger
  6 | Tiger
  7 | Tiger
  8 | Scott
  9 | Scott
  </code></pre>
  
  <p>I tried this but it doesn't work:</p>
  
  <pre><code>=IF( ISBLANK(CELL("contents")),INDIRECT("A" &amp; ROW() - 1),"")
  </code></pre>
  
  <p>I'll get either a Circular Reference Warning or just the value 0.  This is for Excel 2010</p>