非空 非 Y編號 提取 (12154)

(先)M2{=IFERROR(INDIRECT(TEXT(SMALL(IF((B$2:J$14<>"")*(B$2:J$14<>"Y")*(COUNTIF(M$1:M1,B$2:J$14)=0),ROW($2:$14)/1%+COLUMN(B:J)),1),"!R0C00"),),"")

N2{=IF(M2="","",INDEX(A:A,MIN(IF(B$2:J$14=M2,ROW($2:$14))))&TEXT(SUM(N(LEFT(L$1:L1,5)=INDEX(A:A,MIN(IF(B$2:J$14=M2,ROW($2:$14)))))),"-0;;"))