excel 同一个id,如何按照某一列中的内容重新编码到另一列?答:=IF(COUNTIF(A$2:A$10,A2)=COUNTIFS(A$2:A$10,A2,B$2:B$10,B2),IF(B2="是","A","B"),"C")=MID("ACB",ROUNDUP(SUM(IF(OFFSET(B$1,MATCH(A2,A$2:A$10,),,COUNTIF(A$2:A$10,A2))={"是","否"},{1,3}))/COUNTIF(A$2:A$10,A2),),1)数组公式,三键结束。...