How to rank based on text criteria

[ORoxo]

Hey, everyone,

I need your help because I have on column A the name of the departments and on column B a specific number with regards to a specific risk. The thing is, each department can have multiples risks so I can have 10 lines for department A with different numbers on column B.

On column C I wish to have a ranking for those numbers bu specific to deparment. Lets say I have Department A from rows 2 to 10 and Deparment B from 11 to 20. I would need the formula to have a criteria on the department

Any hints?
Thanks!

EDIT: Same department can have the same number on column B, in that case I would like to ignore it and just give it the following number in the rank

 

[ORoxo]

I was able to do it with SUMPRODUCT but I haven't figure out how to ignore duplicates

 

[Marcelo Branco]

A data sample along with desired results would be helpful.

M.