如图excel中,怎样用公式得出成绩为E列的班级排名的第一名的同学的姓名...答:进步最大:=INDEX(B2:B7,MATCH(LARGE(G1:G7,1),G1:G7,0))=INDEX(B2:B7,MATCH(LARGE(G1:G7,2),G1:G7,0))=INDEX(B2:B7,MATCH(LARGE(G1:G7,3),G1:G7,0))=INDEX(B2:B7,MATCH(LARGE(G1:G7,4),G1:G7,0))=INDEX(B2:B7,MATCH(LARGE(G1:G7,5),G1:G7,0))退步...