Ranking with no gaps

I need help with a formula that will give me a ranking but does not have gaps in the numbers. The ranking is based on a couple criteria like what date and department they are in.

example
Name Dept Points Ranking Should Look like
Carol Ops 4 1 1
Tanya Ops 5 2 2
Nicole Ops 11 3 3
Frank Ops 11 3 3
Dianna Ops 13 5 4
Robyn Ops 15 6 5
Stu Exp 4 1 1
Lindsey Exp 8 2 2

This is the formula I have but it gives gaps

Please Login or Register  to view this content.

The formula does not relate to the data.

Sorry I quickly did the example and the formula I pulled out of my spreadsheet.

Department Class Total Weekly Points Rank Want
Ops 400 4 1 1
Ops 400 5 2 2
Ops 400 11 3 3
Ops 400 11 3 3
Ops 400 13 5 4
Ops 400 15 6 5
Exp 403 8 2 2
Exp 403 4 1 1