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
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)