title: Formula to compare a set of cells and return value
body: <p>My formula is</p>
  
  <pre><code>{=IFERROR(IF(MAX(IF(N17:$N$32="D",ROW(N17:$N$32)))=
   MIN(IF(ISBLANK(E17:$E$32),ROW(E17:$E$32)))-E17,"D",""),"")}
  </code></pre>
  
  <p>Basically, the rows are delegated to two different types: the parent and the child. </p>
  
  <p>The type shifts if a variable changes in another cell. This formula's purpose is to identify how many rows below it still are child rows, and then (with D being placed in the next cell) determine if the child is complete. If all the children below the parent row are complete, then the current cell should return the value "D".</p>
  
  <p>This formula does currently work... but is only able to identify if the last cell of the children is complete. It does not check what children between it and the parent have any data put in or not. </p>