I am trying to create a fantasy football playoff bracket to see what needs to happen in order for teams to make the playoffs.
First, so far, I have the team standings, and there are 3 weeks left in the season. The team with the highest record from each division makes playoffs, and the next best team from any division (first by overall record, then division record) make the playoffs as a wildcard.
I need a function that looks through each division to find the team with the highest overall record, if there is a tie, it displays the team with the highest division record. THEN it searches ALL remaining teams for highest record (if a tie, displays highest division record), and displays it.
I have all teams with overall wins in one column, losses in another, division wins in another, and division losses in another. (Losses should not need to be used in the function as we just need highest wins, right?)
What functions should I use?
First, so far, I have the team standings, and there are 3 weeks left in the season. The team with the highest record from each division makes playoffs, and the next best team from any division (first by overall record, then division record) make the playoffs as a wildcard.
I need a function that looks through each division to find the team with the highest overall record, if there is a tie, it displays the team with the highest division record. THEN it searches ALL remaining teams for highest record (if a tie, displays highest division record), and displays it.
I have all teams with overall wins in one column, losses in another, division wins in another, and division losses in another. (Losses should not need to be used in the function as we just need highest wins, right?)
What functions should I use?
