clueless_monkey
New Member
- Joined
- Jan 19, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using:
In fact, this works perfectly when sorting smallest to largest:
In a ranking of 125 locations, 50 are tied for first along with a few other ties on the way down the rankings, which puts last place at 54th - just as expected:
The issue that I am running into, however, is that when I change the sort from smallest to largest, last place is now ranked 61st
Is there any other ranking function I can use to keep ranking consistent regardless of sorting?
Excel Formula:
=SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129))
In fact, this works perfectly when sorting smallest to largest:
In a ranking of 125 locations, 50 are tied for first along with a few other ties on the way down the rankings, which puts last place at 54th - just as expected:
The issue that I am running into, however, is that when I change the sort from smallest to largest, last place is now ranked 61st
Is there any other ranking function I can use to keep ranking consistent regardless of sorting?