Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Oct 30, 2025

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
excel
Formulas and Functions
  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Oct 31, 2025

    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's avatar
      sf49ers19238597
      Iron Contributor
      Nov 19, 2025

      I need help with the average. Week 1 and week 2 no average. week 3 to week 16

       

      look a week  sample week 1 and week 2  get average for week 3 until week 16

       

      • m_tarler's avatar
        m_tarler
        Bronze Contributor
        Nov 20, 2025

        see attached

        =AVERAGE(TAKE(FILTER(INPUT_SCORES!$B$2:$S$33,INPUT_SCORES!$A$2:$A$33=TRIM('THURSDAY GAMES '!C8)),,$A8-1))

         

        If you like my help feel free to give me likes :)

Resources