EXCEL表格比较三组数的大小并显示最大的数对应的人?答:=IF(COUNTIF(B2:B4,B2)=3,"平手",IF(COUNTIF(B2:B4,MAX(B2:B4))=2,INDEX(A2:A4,MATCH(MAX(B2:B4),B2:B4,))&","&LOOKUP(1,0/(B2:B4=MAX(B2:B4)),A2:A4),INDEX(A2:A4,MATCH(MAX(B2:B4),B2:B4,)))或 =IF(COUNTIF(B2:B4,B2)=3,"平手",INDEX(A2:A4,MATCH(MAX(B2:...