Home › Forums › Power Pivot › How to Rank a list based on a second value to handle ties? Tagged: RANKX This topic contains 2 replies, has 2 voices, and was last updated by fenixen 2 years, 9 months ago. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts June 18, 2016 at 10:54 pm #4997 fenixenParticipant Started: 7Replies: 12Total: 19 Current formula is as follows: Overall Rank= RANKX(all(‘EM2016 Participants’);[Points]) This ranks all the participants by Sum([Points]), works like a charm.. BUT.. we want the RANK to be affected by a second column/value to determine the leader amongst the people with same score. As we can see 7 people have an overall rank of 1. But when rank is identical “U poeng” should determine who the leader is. Currently its only sorted alphabetical. Is it possible to do some sort of nested RANKX that gives rank based on two measures? Nikil with 3 U points should be the last of Rank=1. Ideally only one person should be rank 1 here and that is Bjørn since he is the only one with U poeng= 6. Attachments:You must be logged in to view attached files. June 20, 2016 at 6:21 pm #5007 tomallanKeymaster Started: 7Replies: 2554Total: 2561 Remi, Try creating a calculated column with the following formula: Points with Tie Breaker= [Poeng] + ( [U poeng] / 1000 ) then rank on that calculated column. Am sure you have done something like this before. Tom June 20, 2016 at 7:41 pm #5010 fenixenParticipant Started: 7Replies: 12Total: 19 Actually haven’t done this, probably “hacked” stuff in regular Excel instead.. So PAINFULLY obvious when I read your answer, thank you, worked perfectly! 🙂 Author Posts Viewing 3 posts - 1 through 3 (of 3 total) You must be logged in to reply to this topic.