if statement help

have a list showing list of teams fixutures

column a
team a u14 v. ivy
team a u15 v. abc
efg. v fgm
team a u12 v. who

list goes on

I only want to bring onto new sheet. if column A contains team 'a'


I assume its a array/if statement

Take a look at the yellow banner at the top of the screen, and act upon it, i.e. attach a sample Excel file (not a picture of one) which will help us to see how your data is laid out as well as what you want to achieve.

Hope this helps.

Pete

see attached

'filter out' tab shows what I'm struggling with

ideally would like to do a pivot table but you can't add data validation to a pivot table

I still can't get my head around it

thought...filter formula?

thanks. that works a treat.

raw data looks messy as sometimes the fixtures per age group increase hence few spaces in between