Pull Rows from a table based on todays date and another data set.

[AKTriple5]

Put as simply as possible, I work at a Movie Theater and am trying to organize all the movie posters we have. We have an excel file with the Movie Title, Release Date, # of Copies, and If we are currently showing it.

I would like to make a second table that grabs an entire column by first looking for anything past today's date, then by checking to see if the last Column has a Y or an N. If it is past today's date and there is an N, then we are good to be rid of the poster.

So I was wondering if there was a formula to do just that?

[#2]

@AKTriple5 

=IF(AND($B3<TODAY(),$D3="N"),A3,"")

You can try this formula to identify the posters to get rid of. If you work with Excel 2019 or later or with Excel for the web you can use the FILTER function. Another alternative could be advanced filter which works for older versions of Excel as well.

[#3]

@OliverScheurich 

I have typed the equation with only small adjustments to fit my table, and it's only popping up with the first title listed and nothing after the fact

[#4]

Nevermind. I copy/pasted it to be right next to the existing table and it works now