Need help for Ranking tie-breaker problem

Hi Excel Forum Gurus and Experts,

I need help in resolving the ranking ( for a subset of elements in Column B) based on the tie-breaker criteria ( column C). The additional challenge is the resolution should be normally downward ( for e.g. two values of 9 should be resolved as 9 and 10) except for the last values in the set . For e.g. if there is a tie for 2 candidates with the value 17 in the example, it should be resolved as 16 and 17 and not as 17 and 18. The expected results are in column D.

Any help or guidance is much appreciated.

Thanks and Regards,

Thanks a lot Bernie.