我试图在此图表中进行有条件排名:
On the right you can see the total score and ranking from the Match 1,2,3
(sum)
on line A
and C
I have a tie score (3 points and both ranked at 2nd place), I'd like to to add a 2nd and 3rd conditions to determinate the final ranking.
If there is a tie in score (both are in same ranking), then to determine who is 2nd and who is 3rd place I want to use the values from the XX's
column first. The higher value will win the 2nd place and in a case there is still a tie (as both are the same value of 0), it will continue and check the value on the X's
column and since line C
= 27 and line A
= 21, line C
will be ranked as 2nd place and line A
will be ranked as 3rd place.
Also will like to add an option to continue with 3 condition if there is still a tie.
我正在使用一个简单的排名公式=RANK(AK7,$AK$7:$AK$10)
来确定排名。
非常简单的“数学”解决方案:与权重进行线性组合。
做类似的事情
Wscore = 1000*Score + 10*XXvalue + Xvalue
然后使用简单的排名函数对值进行排序。
如果需要,只需根据您的值分布更改权重即可。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)