title: Dynamic Helper Column?
body: <p>I wish to create a helper cell using a dynamic array, Is this possible?</p>
  <p>Normally I use a formula such as in this example <code>=IF(A4=&quot;&quot;,C2,A4)</code> which check if column A is blank and if so just copies the above value until a new value appears in column A.</p>
  <p>However as shown in the image when I insert New rows the helper cell becomes broken.</p>
  <p>For this reason I wanted to use a dynamic array to create the helper cell which should be able to handle rows inserted or removed.</p>
  <p>The problem I have is that unlike a normal formula which you can just drag down, a dynamic array is looking at the values as a whole. Using <code>=IF(A4:A40=&quot;&quot;,&quot;-&quot;,A4:A40)</code> inserts a hyphen as shown in the image. Essentially I wish to replace the hyphen such that &quot;For each value between A4:A40 check if blank and if true take the value in the above cell&quot;.  In essence creating a dynamic helper column.</p>
  <p><a href="https://i.stack.imgur.com/936AI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/936AI.png" alt="enter image description here" /></a></p>