excel如何找出A列和B列相同之处并在B列显示答:=IF(COUNT(FIND(0,A1:B1))=2,0,"")&SUM(LARGE(IF(FREQUENCY(IF(ISERROR(--(MID(A1,ROW($1:$50),1))),10,--(MID(A1,ROW($1:$50),1))),ROW($1:$10)-1)*FREQUENCY(IF(ISERROR(--(MID(B1,ROW($1:$50),1))),10,--(MID(B1,ROW($1:$50),1))),ROW($1:$10)-1...