title: Excel Concatenate with IFS and AND/OR
body: <p>I need to concatenate Descriptions in Column G, but only those description where Column D(SearchType) = 7. </p>
  
  <p>The Concatenated Description must also just reflect on the last line before the DocumentNumber (Column B) resets and only include those Searchtype 7 descriptions of the same DocumentNumber.</p>
  
  <p>I've tried multiple <code>AND</code> , <code>OR</code>. <code>IF</code>, <code>IFS</code> and <code>CONCATENATE</code> variations, but don't seem to get it right. Such as</p>
  
  <pre><code>=+IF(AND(F4=0,F3&lt;&gt;0,F2&lt;&gt;0,F1&lt;&gt;0),CONCATENATE(G4,G3),FALSE)
  </code></pre>
  
  <p>but I cannot figure out how to "Reset" the formula </p>
  
  <p><img src="https://i.stack.imgur.com/Y1M2l.jpg" alt="image"></p>