Hi,

Thanks in advance for your help. I have a list below which is very long, for the cost entry in column A there are something like 200 costs. Each cost is repeated for each department (A to E). What I would like to do is write a forumla that ranks the departments by the turnover percentage, but against each cost type. For example, the first cost type is Salaries, the 5 departments (A to E) are then ranked 1 - 5 based on the percentage column. However the cell references have to be fixed against the first entry which means when I drag this formula down =RANK(C1,$C$1:$C$5), the range doesn't move. Manually moving this formula down on the number of rows would take hours. Is there a way for it to calculate the rang only against each individual cost entry in column A.


HTML Code: 


Thanks again.

I have included an attachment to make it clearer since Im not sure how to add the table

AlexRanking Test.xlsx