A3:A20{=IFERROR(INDEX(G:G,LOOKUP(SMALL(IF(G$2:G$20="",ROW($2:$20)),ROW(A1)),IF(G$2:G$20<>"",ROW($2:$20)))),"")
B3:E20{=IFERROR(OFFSET($G$1,MATCH($A3,$G:$G,)+COUNTIF($A$3:$A3,$A3)-1,MATCH(B$2,VLOOKUP($A3,$G:$L,COLUMN($B:$F),),))&"","")
A3:A20另解{=INDEX(G:G,SMALL(IF(G$2:G$20="",LOOKUP(ROW($1:$19),IF(G$2:G$20<>"",ROW($1:$19)),ROW($2:$20)),99),ROW(A1)))&""
留言
張貼留言