Forum Discussion
Pull Rows from a table based on todays date and another data set.
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 curr...
=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.
- Nevermind. I copy/pasted it to be right next to the existing table and it works now
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