Rank - Change the Rank of a Tie

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top