title: List all values in excel range with a condition and date range
body: <p><a href="https://i.stack.imgur.com/FErhK.png" rel="nofollow noreferrer">My excel data example</a></p>
  
  <p>I have two conditions to draw the value in another sheet:</p>
  
  <ol>
  <li>Customer name</li>
  <li>Date Range From... To...</li>
  </ol>
  
  <hr>
  
  <p><strong>Example:</strong></p>
  
  <pre><code>I would like to draw all Campaign number that related to Customer from 01/03/2019 to 21/03/2019.
  </code></pre>
  
  <p><strong>Expected Result</strong></p>
  
  <pre><code>Choose: Customer A, Date from 01/03/2019 to 20/03/2019 -&gt; CPC1
  Choose: Customer A, Date from 01/03/2019 to 21/03/2019 -&gt; CPC1, CPC3
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/mAEax.png" rel="nofollow noreferrer">I would like the result like this</a></p>
  
  <p>Could anyone suggest me what is the formula in excel to achieve this?</p>