跳欄 依數重複顯示 (14377)

F3:I3 下拉=IF(ROW(A1)>SUM($B:$B),"",IF(LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET($B$1,,,ROW($1:$9))),ROW($1:$9))=MATCH(F$2,$A:$A,)-1,VLOOKUP(F$2,$A:$C,3,),""))