I'm trying to include Standings on my fantasy football spreadsheet.
I need to Rank first by winning percentage and then by Points Scored as a tie breaker. For example, two teams are 7-5, and "tied" for third place but one team has scored 1050 points while the other has scored 1000. I want the team that scored 1050 to have a Rank of 3 and the team that scored 1000 to have a Rank of 4 instead of both of them having a rank of 3 out of 10.
I have the winning percentages and Points Scored in very different places on my spreadsheet.
I've tried many different things and scoured these forums for a similar problem but can't figure it out. There has to be a way to do this.
I would attach my spreadsheet but it's an invalid file type.
Thanks for any help!
Bookmarks