指定區數據 緊接顯示 (10758)

G2:H13{=IFERROR(INDEX(B:B,SMALL(IF(INDEX($F:$F,SMALL(IF(COUNTIF($A:$A,$F$2:$F$7)>=COLUMN($A:$I),ROW($2:$7)),ROW(A1)))=$A$2:$A$16,ROW($2:$16)),RIGHT(SMALL(IF(COUNTIF($A:$A,$F$2:$F$7)>=COLUMN($A:$I),ROW($2:$7)/1%+COLUMN($A:$I)),ROW(A1)),2))),"")