title: Excel how to return an array that meets a certain condition?
body: <p>If I have data in cell range <code>A1:A6</code> which is:</p>
  
  <pre><code>Apple
  Banana
  Cherry
  Grape
  Orange
  Watermelon
  </code></pre>
  
  <p>Is there a way to return an array (in a single cell, for an intermediate step for a larger formula) which returns the above array except only those entries that satisfy a certain condition?</p>
  
  <p>For example, if I wanted a formula to return an array of only those cells that contain the letter <code>n</code>, it would return this:</p>
  
  <pre><code>Banana
  Orange
  Watermelon
  </code></pre>
  
  <p>Is there a way to accomplish this?</p>
  
  <p>Note I do <em>not</em> want to return an array of the same size, just with blank entries, i.e. I do not want:</p>
  
  <pre><code>""
  Banana
  ""
  ""
  Orange
  Watermelon
  </code></pre>