D2:D5{=INDEX(A:A,SMALL(IF(B$2:B$10="",ROW($2:$10),99),ROW(A1)))&""
E2:H5{=IFERROR(LOOKUP(1,0/(TRIM(MID(SUBSTITUTE(OFFSET($A$1,MIN(IF((LOOKUP(ROW(1:9),ROW(1:9)/($B$2:$B$10=""),$A$2:$A$10)=$D2)*($B$2:$B$10<>"")*ISNUMBER(FIND(E$1,$A$2:$A$10)),ROW($1:$9))),),",",REPT(" ",9)),{1,10,19},9))=E$1),TRIM(MID(SUBSTITUTE(OFFSET($B$1,MIN(IF((LOOKUP(ROW(1:9),ROW(1:9)/($B$2:$B$10=""),$A$2:$A$10)=$D2)*($B$2:$B$10<>"")*ISNUMBER(FIND(E$1,$A$2:$A$10)),ROW($1:$9))),),",",REPT(" ",9)),{1,10,19},9))),"")
留言
張貼留言