D2:H2{=SUM((MID(TRANSPOSE($A2:$A21),9,3)-$L3:$L12=0)*(LOOKUP(ROW(3:12),ROW(3:12)/($M3:$M12<>""),$M3:$M12)=D1))
另解=SUMPRODUCT((LOOKUP(ROW(3:36),ROW($3:$36)/($M3:$M36<>""),$M3:$M36)=D1)*COUNTIF($A:$A,"????????"&$L3:$L36&"?????"))
區域數組{=TRANSPOSE(FREQUENCY(MID($A2:$A21,9,3)*1,{112,113,116,119}))
留言
張貼留言