Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jan 16, 2022
I look at file. the formula is look at wrong place in divisional round it should look at score that are in green color area I put score .


Thanks You


  • mtarler's avatar
    mtarler
    Silver Contributor
    Jan 16, 2022

    sf49ers19238597 I looked at the file and did find a 'bug' but i don't think it is what you think.  The RANK for the divisional round is actually looking at the cells to the right of the scores that LOOK blank but actually have formulas in them to pull the rank of the winner.  Because of how you said it works, it doesn't fill it in until all 3 results are completed (i.e. not smart enough to say if rank 2 won that it must be the lowest rank ...).  The 'bug' i did find was that when I copied the formulas from the upper bracket to the lower bracket I missed moving 1 range in each.  That has been corrected in the attached.

    • sf49ers19238597's avatar
      sf49ers19238597
      Iron Contributor
      Jan 23, 2022
      i saw file in divisional need to change teams around teams higher seed should be on top line. teams on bottom be on top line.lower seeds should be on bottom

      should look something like this

      DIVISIONAL ROUND

      AFC

      4 Bengals
      1 TITANS


      3 BILLS
      2 CHIEFS
      NFC
      6 49ERS
      1 PACKERS

      5 RAMS
      2 BUCCANEERS

      Thanks you





Resources