Comparing three columns for the rank.

[jrm_ayun]

I am way in over my head. I'm trying to make a spreadsheet for our future events that would automatically rank the people via the highest of three scores. In case of ties, it will then compare the other two scores to see who had the highest one there. If there are still ties, then whoever inputted their name first should be higher. Here are the problems. In this example, Lito should be ranked 1 since he has 3 as another score instead of Jay's 2. Then you can also see that She and James share the same rank but should be higher. The ranking also doesn't count down really. The first one to write is higher I have no syntax for yet although my syntax right now is obviously wrong for the other ones I'm looking for.

=RANK(E2,$E$2:$E$9)+SUMPRODUCT(--(E2=$E$2:$E$9),--(B2 < $B$2:$B$9),--(C2 < c$2:$c$9),--(d2 < d$2:d$9))

 

[DRSteele]

Welcome to the forum.

If I interpret correctly, what you need is an algorithm that cascades the tie-breakers for successive criteria. See this post, follow the links and let us know if that helps.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.mrexcel.com/forum/excel-questions/1054878-assigning-points-teams-based-place-conference-standings.html#post5066024[/FONT]