Hi Everyone,
this might be a lame question and the title for the psot might be wrong aswell but I will ask it and get told off after
I'm making my own fantasy nba league for the upcoming season..
I have everything under control except for the scoring system.. I have seen worldcup spreadsheet where as the score is entered it moves them around the ladder from position 1 to position 4 and so on.
I have a calculating system where each round there are scores being entered and another sheet adding up the scores and also what the opposition socres on them and a percentage but.
How can I do it so if
Team 1 has a % of 80
and Team 3 has a % of 79
and team 2 has % of 114
then it would be ranked 2
3
1
but then the following round is played and now the %
is team 1 - 85%
team 2 - 90%
team 3 - 71
so it will automatically move the stats around and put team 1 upto position 2 and team 3 down to 3.
I hope this makes sense if anyone can help that would be great
thanks.
Bookmarks