如题所述
D2è¾å ¥
=IF(COUNTIF($A1:$C1,A2),A2,"")&IF(COUNTIF($A1:$C1,B2)*(A2<>B2),B2,"")&IF(COUNTIF($A1:$C1,C2)*(A2<>C2)*(B2<>C2),C2,"")
å ¬å¼ä¸æ
D2=REPT(A1,MIN(COUNTIF(A1:C1,A1),COUNTIF(A2:C2,A1)))&IF(B1=A1,"",REPT(B1,MIN(COUNTIF(A1:C1,B1),COUNTIF(A2:C2,B1))))&IF(OR(C1=A1,C1=B1),"",REPT(C1,MIN(COUNTIF(A1:C1,C1),COUNTIF(A2:C2,C1))))
谢谢啦 沈老师 元旦快乐