201910231031按数量重新并且相连 (6197)

A2:A6=SUM(C$1:C1)+1

F2:F14=VLOOKUP(ROW(B1),A:B,2,1)&""

方式二=LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(C$1,,,{1,2,3,4,5})),B$2:B$6)&""

方式三{=IFERROR(INDEX(B:B,SMALL(IF(COLUMN(A:Z)<=C$2:C$5,ROW($2:$5)),ROW(A1))),"")

方式四{=INDEX(B:B,SMALL(IFERROR(--MID(REPT(ROW(B$2:B$5),C$2:C$5),COLUMN(A:I),1),4^8),ROW(1:1)))&""

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite