Excel一个单元格比对一列,统计相同项个数答:B1 粘贴公式 =SUM(IF(IFERROR(MATCH(TRANSPOSE(MID(D2,1+LARGE(IFERROR(LARGE(IFERROR(IFERROR(IF(FIND(" ",$D2,ROW(INDIRECT("A1:A"&LEN($D2)))=FIND(" ",$D2,1+ROW(INDIRECT("A1:A"&LEN($D2))),0,FIND(" ",$D2,ROW(INDIRECT("A1:A"&LEN($D2))),FIND(" ",$D2,...