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