title: Excel Grouped Columns check if children contain data
body: <p>I have a spreadsheet that contains a list of e.g software products, some products go up to module level and others are just a product. I have a grouping that groups each vendors products or product modules... </p>
  
  <p>the excel sheet aims to map vendor products (or modules if they exist) to certain functions. an "X" in the cell indicates that the function is supported. in the picture module A1.1 supports function 1. ... and Product A2 (with no defined modules)  also supports Function 1.</p>
  
  <p>The problem comes in when working up the "tree" of grouped columns... i need a sub/function that will complete the rest of the mapping. ie... if i check both cell D2 and E2 i would like to run a function that updates cell C2 to an X and then Cell B2 to an X.  (the X would state that all modules support the function) </p>
  
  <p>So in the graphic, the red cells were manually entered, and the non-red "X" and "O" cells would be added automatically.</p>
  
  <p>I know this seems lazy asking in this format, however i would appreciate help even to get directed in the right idea, brain is fried and i cant even think how to solve this... </p>
  
  <p><img src="https://i.stack.imgur.com/6CbRx.png" alt="enter image description here"></p>