title: How do I pull values from one sheet to another, based on parameters?
body: <p>I have a Google Sheet. I have tagged excel in case the solution would be the same, or if there is not solution at all I may consider excel.</p>
  
  <p>I have a sheet with a list of names, and whether or not they are attending a weekly event of football.</p>
  
  <p>The list of people is around 30 and we usually only get 10.</p>
  
  <p>I'd like a way to be able to display only the people who are yes.</p>
  
  <p>I have attached an image of my sheet.</p>
  
  <p>I am thinking I would want to create another sheet and then pull through the only the values from column A where the corresponding value in AA = 'Yes'.</p>
  
  <p>I am not sure where to start with this though. </p>
  
  <p>Any ideas or can anyone point me in the right direction?</p>
  
  <p><a href="https://i.stack.imgur.com/M7ezh.png" rel="nofollow"><img src="https://i.stack.imgur.com/M7ezh.png" alt="enter image description here"></a></p>