如图，G2公式：
=IF(INDEX($B:$B,MAX(IF(($A$2:$A$31=$F2)*$C$2:$C$31=LARGE(($A$2:$A$31=$F2)*$C$2:$C$31,COLUMN(A1)),ROW($2:$31))))=F2,INDEX($B:$B,LARGE(IF(($A$2:$A$31=$F2)*$C$2:$C$31=LARGE(($A$2:$A$31=$F2)*$C$2:$C$31,COLUMN(A1)),ROW($2:$31)),COUNTIF($F2:F2,F2)+1)),INDEX($B:$B,MAX(IF(($A$2:$A$31=$F2)*$C$2:$C$31=LARGE(($A$2:$A$31=$F2)*$C$2:$C$31,COLUMN(A1)),ROW($2:$31)))))
ctrl+shift+回车，右拉后下拉
分数相同怎么处理
写代码可以实现
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024