Hello,
I'm trying to display names in order of rank, based on the value next to the names.
It doesn't work when there's a tie.
Does anyone know how to get it to work, such as with some sort of tie-breaker? Thanks a lot
Hello,
I'm trying to display names in order of rank, based on the value next to the names.
It doesn't work when there's a tie.
Does anyone know how to get it to work, such as with some sort of tie-breaker? Thanks a lot
try this rank formula with a countif at the end. It breaks ties...
=RANK(B2,B$2:B$10,0)+COUNTIF($B$2:B2,B2)-1
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks