Ranking Based on Critera

I'm having trouble ranking certain columns based on the criteria in another cell.

In my attached sheet, I want to rank columns AS:BB based on the number of teams entered in cell AE8. I have a total of 20 teams possible with ranks set up for them, the problem I'm running into is if I select 12 teams I want it to only rank the first twelve rows (16-27) of columns AS:BB but how I have it setup it's still ranking all 20 rows thus not providing an accurate ranking. If 12 teams are selected, I would want the last 8 rows (28-35) of columns AS:BB to be blank and not have a rank.

Same thing goes for all the other possible selections in cell AE8 which consists of team sizes of 8,10,12,14,16,18,20.

My worksheet is attached. Thanks!