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!

Can you pls explain what is difference from this(your own) thread?

http://www.excelforum.com/excel-form...-criteria.html

Originally Posted by mlbdc2012

Completely different worksheets. I'm new to excel so I don't have much experience.

The fact that you are new to Excel is one point.

But what i asked for you to explain why these are differents, BECAUSE LOOKS TO ME THAT IS THE SAME REQUEST.

Also you modified your attachment after my question....

Problem is that

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.