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