指定五數字全同 取出期別 (12306)

N2{=INDEX(A:A,SMALL(IF(MMULT(N(COUNTIF(OFFSET(B$1:F$1,ROW($1:$19),),H$2:L$2)*COUNTIF(OFFSET(B$1:F$1,ROW($1:$19),),B$2:F$16)>0),ROW(1:5)^0)=5,ROW($2:$20),99),ROW(A1)))&""



留言