I'm trying to tie the name of a team to their wins and losses so that they ascend or descend based on their performance and on other team performances.
What exactly would be the formula to establish this linking. It would have to involve both the team name, the team record and win percentage as well as changing the GB (games behind). A lot of people have written on this subject but no one seems to have the be all end all series of formulas. Here's my layout per column in order . . .
Team(s), Wins, Losses, Ties (if any), Games Played, Win%, and Games Behind
I'd like to have two sheets, one sheet where teams are organized by division (or conference) and another one by league (or even wild-card). I really appreciate the help get on this one.
Thanks in advance.
What exactly would be the formula to establish this linking. It would have to involve both the team name, the team record and win percentage as well as changing the GB (games behind). A lot of people have written on this subject but no one seems to have the be all end all series of formulas. Here's my layout per column in order . . .
Team(s), Wins, Losses, Ties (if any), Games Played, Win%, and Games Behind
I'd like to have two sheets, one sheet where teams are organized by division (or conference) and another one by league (or even wild-card). I really appreciate the help get on this one.
Thanks in advance.
