出現數字 找出 (15148)

C2:K7=IF(1-ISERR(FIND(" "&C$1&" "," "&$B2&" ")),C$1,"")

用COUNTIF=REPT(C$1,SUMPRODUCT(COUNTIF(C$1,TRIM(MID(SUBSTITUTE($B2," ",REPT(" ",29)),ROW($1:$9)*29-28,29))*1)))



留言