继续昨日的故事

EXCEL问题（续昨日继续找数）

公式如下： =IF(ISNA(MATCH(A1,A2:I2,)),A1,"")&IF(ISNA(MATCH(B1,A2:I2,)),B1,"")&IF(ISNA(MATCH(C1,A2:I2,)),C1,"")&IF(ISNA(MATCH(D1,A2:I2,)),D1,"")&IF(ISNA(MATCH(E1,A2:I2,)),E1,"")&IF(ISNA(MATCH(F1,A2:I2,)),F1,"")&IF(ISNA(MATCH(G1,A2:I2,)),G1,"")&IF(ISNA(MATCH(H1,A2:I2,)),H1,"")&IF(ISNA(MATCH(I1,A2:I2,)),I...全部

  公式如下： =IF(ISNA(MATCH(A1,A2:I2,)),A1,"")&IF(ISNA(MATCH(B1,A2:I2,)),B1,"")&IF(ISNA(MATCH(C1,A2:I2,)),C1,"")&IF(ISNA(MATCH(D1,A2:I2,)),D1,"")&IF(ISNA(MATCH(E1,A2:I2,)),E1,"")&IF(ISNA(MATCH(F1,A2:I2,)),F1,"")&IF(ISNA(MATCH(G1,A2:I2,)),G1,"")&IF(ISNA(MATCH(H1,A2:I2,)),H1,"")&IF(ISNA(MATCH(I1,A2:I2,)),I1,"") 请看附件。
  收起