字母重複顯示 依重複數 (12776)

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

G2{=INDEX(B:B,SMALL(IF(C$3:C9>=COLUMN(A:I),ROW($3:9),99),ROW(A1)))&""



留言