四格都出現數字 (14218)

D2{=TRIM(MID(SUBSTITUTE(B$1,",",REPT(" ",29)),SMALL(IF(MMULT({1,1,1},1-ISERR(FIND(","&TRIM(MID(SUBSTITUTE(B$1,",",REPT(" ",29)),COLUMN(A:I)*29-28,29))&",",","&B$2:B$4&",")))=3,COLUMN(A:I),99),ROW(A1))*29-28,29))



留言