按指定次数重复两列

风雨相随3

用函数按指定次数重复两列? 按指定次数重复两列.zip (8.66 KB, 下载次数: 50)

2025-11-4 20:52 上传

点击文件名下载附件

良良

=IFERROR(INDEX(A:A,SMALL(IF($C$2:$C$5>=COLUMN($A:$Z),ROW($2:$5)),ROW(A1))),"")

良良

非数组：
=LOOKUP(,0/FREQUENCY(ROW(A1),MMULT(N(ROW($1:$4)>=COLUMN($A:$D)),$C$2:$C$5)),A$2:A$5)&""

leepoison

=REDUCE(A1:B1,C2:C5,LAMBDA(x,y,VSTACK(x,IF(SEQUENCE(y),OFFSET(y,,-2,,2)))))

gwjkkkkk

1. =LOOKUP(ROW(A1)-1,SUMIF(OFFSET($C$1,,,ROW($1:100)),">0"),A$2:A100)&""

复制代码

右拉下拉

9999剑

1. let
   
2.     源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
   
3.     数量转列表 = Table.TransformColumns(源,{"薪级",each {1.._}}),
   
4.     列表展开到行 = Table.ExpandListColumn(数量转列表, "薪级"),
   
5.     删除数量行 = Table.RemoveColumns(列表展开到行,{"薪级"})
   
6. in
   
7.     删除数量行

复制代码

9999剑

1. =REDUCE(A1:B1,C2:C5,LAMBDA(x,y,VSTACK(x,IF(SEQUENCE(y),OFFSET(y,,-2,,2)))))

复制代码

你是那块小饼干

1. =REDUCE(A1:B1,C2:C5,LAMBDA(x,y,VSTACK(x,IF(SEQUENCE(y),OFFSET(y,,-2,,2)))))

复制代码

xtmyd5156

1. =REDUCE(A1:B1,A2:A5,LAMBDA(X,Y,VSTACK(X,REPTARRAY(HSTACK(Y,OFFSET(Y,,1)),OFFSET(Y,,2)))))

复制代码

A九月

=LET(DATA,A2:C5,R,TAKE(DATA,,-1),ARR,SEQUENCE(SUM(R)),BRR,SCAN(0,R,SUM),C,XMATCH(ARR,BRR,1),DROP(CHOOSEROWS(DATA,C),,-1))