Excel 根据成绩来提取前10学生信息,当有并列名次时,则要把所有的都提 ...答:A2=IF(COUNTIF(D$2:D$1000,D2)>1,D2-ROW()/10000,D2)向下填充公式,这里支持999人中选择前10名(分值不能有0.01分,如88.23分)隐藏A列 结果在Sheet2 B2=VLOOKUP(LARGE(Sheet1!$A$2:$A$1000,$A2),Sheet1!$A$2:$D$1000,2,FALSE)C2=VLOOKUP(LARGE(Sheet1!$A$2:$A$1000,$A2...