title: EXCEL: Extracting parts of a list based on one criterion
body: <p>apologies if this is a repeat question. I don't <em>think</em> I came across the right solution for my case.</p>
  <p>I have a list of students who attended different programs and some additional performance info. I'm looking to extract a list with all the info included, based on the programs that attended.</p>
  <p><a href="https://i.stack.imgur.com/uFP5B.png" rel="nofollow noreferrer">Example</a></p>
  <p>I'd like the filtering to be automatic and update automatically if more students are added to the original list.</p>
  <p>From what I read there are a number of solutions, so to provide additional context on my limitations:</p>
  <ul>
  <li>The FILTER() function doesn't seem to be recognized by my Excel</li>
  <li>I tried reading up on INDEX() but it went above my head</li>
  <li>I came across VBAs, which I don't understand, either.</li>
  </ul>
  <p>I hope I gave you enough info.</p>
  <p>Thanks a lot in advance!</p>
  <p>Dan</p>