Rank - Change the Rank of a Tie

  • Thread starter Thread starter jackie
  • Start date Start date
J

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?
 
This:
=RANK(A2,A:A,1)+COUNTIF($A$1:A1,A2)

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