Rank - Change the Rank of a Tie

[jackie]

+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?

 

[Luke M]

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

will modify the rank to increase rank number in case of a tie