Forum Discussion
I am making Thursday night NFL games only
I need formulas for Road teams and home teams. I want to look up the Yearly Schedule worksheet for only the teams that play on Thursday games only not Saturday, Sunday, or Monday. Thanks You
You're lucky I recognize you and still have prior files from you. Here is what you need:
A simple filter formula should work:
=FILTER('YEARLY SCHEDULE'!A5:G276,'YEARLY SCHEDULE'!B5:B276="THU")