Excel,相邻单元格取值,函数,唯一答:在A2输入=IF(COUNTIF(C$1:C2,C2)=1,MAX(A$1:A1)+1,""),在D2输入=IF(ROW()+1>MAX(A:A),"",VLOOKUP(ROW()-1,A:C,3,0),下拉 在E2输入=IF(ROW()+1>MAX(A:A),"",VLOOKUP(ROW()-1,A:B,2,0),下拉
EXCEL中如何使用公式将两列成绩取值最优?答:=IF(COUNTIF(B2:C2,"S3"),"S3",IF(COUNTIF(B2:C2,"S2"),"S2",IF(COUNTIF(B2:C2,"S1"),"S1",IF(COUNTIF(B2:C2,"S0"),"S0",IF(COUNTIF(B2:C2,"黄牌"),"黄牌","红牌")))
EXCEL 怎么实现一行的几个单元格中取想要的字?答:如图:F1公式:=IF(COUNTA(A1:E1),INDEX({"差","一般","好","良","优"},MAX((COUNTIF(A1:E1,{"差","一般","好","良","优"})>0)*{1,2,3,4,5})),0)数组公式,按组合键(CTRL+SHIFT+回车)完成公式,下拉。