重複顯示 依數量 (11534)

E2=LOOKUP(ROW(A1),SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$9)))+1,A$2:A$9)&""

E2=OFFSET(A$2,SUMPRODUCT(N(ROW(A1)>SUBTOTAL(9,OFFSET(B$2,,,ROW($1:$9))))),)&""

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