重複顯現 依顯現數 (13709)

H2=LOOKUP(ROW(A1)-1,MMULT(N(ROW($1:$66)>COLUMN(A:F)),$E$2:$E$7),$D$2:D2)&""

I2=LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(E$1,,,ROW($1:$9))),D$2:D2)&""

J2{=INDEX(D:D,SMALL(IF(E$2:E$7>=COLUMN(A:Z),ROW($2:$7),99),ROW(A1)))&""



留言