So Im sorry if this has been posted somewhere before, I cant remember the term for it to look it up.

This is something I learned how to do in college and did often but I have forgotten what its called and how to do it.

I want a formula or function where i can reference lets say a big list of names, and it only pulls all the names that have an X or something in the adjacent cell. or maybe it only pulls all the names where the adjacent cell is blank. and that new condensed table will update itself if I were to change the data in the adjacent cells.

Can someone tell me how to do that?