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
3 Replies
i try say #spill
you just have to pick the columns you want and make sure there isn't anything else entered in any of the 'spill' cells
=CHOOSECOLS(FILTER('YEARLY SCHEDULE'!A2:G273,'YEARLY SCHEDULE'!B2:B273="THU"),4)
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")
