Rank - Change the Rank of a Tie
 

+Hi- I have set up a rank using a standard ranking formula. I have a total
of 156 items that I am ranking. The values of the rank range from -660 to
756. Most of the values are zero and tie at a rank of 43. The next lowest
rank after all of the 43s is 155. I would like for the rank of the 43s to be
154, not 43. Can I do that with a formula?

Rank - Change the Rank of a Tie
 

This:
=RANK(A2,A:A,1)+COUNTIF($A$1:A1,A2)

will modify the rank to increase rank number in case of a tie
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jackie" wrote:

+Hi- I have set up a rank using a standard ranking formula. I have a total
of 156 items that I am ranking. The values of the rank range from -660 to
756. Most of the values are zero and tie at a rank of 43. The next lowest
rank after all of the 43s is 155. I would like for the rank of the 43s to be
154, not 43. Can I do that with a formula?