Ranking Issue

Hello all,

I'm having a ranking issue that I'd love some help with!

Let's say that I have three columns: Name, Reporting Department, and Salary. I cannot change the current sorting, but I need to rank a list of people by their salaries.

The data is sorted by Reporting Department A-Z then Alphabetical A-Z. I need to reset the rank every time the Reporting Department changes.

How can I make a formula for this?

Thanks in advance for your help!

Update: Just realized I forgot to mention that I have to do this dynamically so new employees can be added in later (without messing up the ranking system).