League Table auto update RANK goes lower than avaliabe on table

I am creating a league table that auto updates based on the fixtures sheet, as well as allowing the user to select a number of teams to use in table.

However due to the number of teams being customisable it is messing with the RANK system that I am using, as if a team is on 0 points but is losing games then there rank will be lowered but due to there being more teams in the dummy sheet this means that if you have a league of 13 teams, then the team that loses will be ranked lower than 13 and as such will not show on the table and would be replaced by a blank team (shown as a 0).

Is there anything I can do to get the unused ranks to don't show up and as such make it so that if 13 teams is selected then the lowest rank to use is 13 but if 34 teams is selected then all 36 ranks will be used.

Any help will be appreciated.

Thanks for the reply JeteMc, that new formula works perfectly, and I understand what it does and how to use it so that is a plus as well, so thanks again for your time in helping me with the problem.