I am making Thursday night NFL games only

Question

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.&nbsp;Thanks You

m_tarler · Answer

see attached=AVERAGE(TAKE(FILTER(INPUT_SCORES!$B$2:$S$33,INPUT_SCORES!$A$2:$A$33=TRIM('THURSDAY GAMES '!C8)),,$A8-1))&nbsp;If you like my help feel free to give me likes :)

m_tarler · Answer

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

sf49ers19238597 · Answer

i try say #spill&nbsp;

m_tarler · Answer

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)

sf49ers19238597 · Answer

I need help with the average. Week 1 and week 2 no average. week 3 to week 16&nbsp;look a week&nbsp; sample week 1 and week 2&nbsp; get average for week 3 until week 16&nbsp;

Forum Discussion

I am making Thursday night NFL games only

7 Replies

Resources