Hi Guys

I am looking for Rank if formula which break the ties and ignore zeros.Below is the output required

Col A Col B Col C
Model Values Rank Output
Model 1 1 4
Model 1 2 3
Model 1 3 2
Model 1 4 1
Model 1 4 1
Model 2 0 0
Model 2 0 0
Model 2 1 3
Model 2 2 2
Model 2 3 1


Request for help, and how to reverse order of the rank?