How to Rank duplicated categories in a list

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

Apologies that is showing as code I am not sure how to paste a table.

Thanks both.

I am hoping there might be a formula that I can use that looks to reset ever 24 rows or when the cost name changes. The reason is there are 100 cost types so I would like to avoid making 100 pivot tables, or having to drag it down 100 times resetting it each time since I will probably have to repeat this exercise with another set of data. I would also like to be able to 'averageif' the rank of each department on the entire data set at the end.

Thanks

Thanks, I see how you have the seperate sections for each cost however the rank column is not included. When I add this I am still not sure how I can then calculate the rank within each cost type?

Say for temporary staff, then for overtime etc.

Thanks