重複顯示 依重複數 (14052)

E2{=INDEX(B:B,SMALL(IF(C$2:C$9>=COLUMN(A:Z),ROW($2:$9),99),ROW(A1)))&""

F2=LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(C$1,,,ROW($1:$8))),B$2:B$9)&""