Ranking in descending order with Zero being the worst

[padkins01]

I searched the forum but couldn't find exactly what I was looking for.

I have a case where I need to have a rank in descending order but, zero needs to be the worst in the rank.


Any help would be appreciated. Thanks!

 

[padkins01]

I realize that this might not make a lot of sense.

To clarify, one of the cells that I am ranking has a value of zero. In this case the value of zero means that nothing was done, so would need to be ranked last.

While the value of 1 means that they did the best. Thanks.

I searched the forum but couldn't find exactly what I was looking for.

I have a case where I need to have a rank in descending order but, zero needs to be the worst in the rank.


Any help would be appreciated. Thanks!