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,"黄牌"),"黄牌","红牌")))