按比例复制行

FindingB

工作簿11.rar (9.26 KB, 下载次数: 16)

2020-10-31 15:07 上传

点击文件名下载附件

我走我流

=IF(OR(MMULT(N(COLUMN(A:C)<=ROW($1:$3)),CEILING($A$2:$A$4/$B$2:$B$4,1))=ROW(A1)),SUM(INDIRECT("a2:a"&LOOKUP(1,0/FREQUENCY(1,N(ROW(A1)<=MMULT(N(COLUMN(A:C)<=ROW($1:$3)),CEILING($A$2:$A$4/$B$2:$B$4,1)))),ROW($2:$4))))-SUM(INDIRECT("r1c:r[-1]c",)),LOOKUP(1,0/FREQUENCY(1,N(ROW(A1)<MMULT(N(COLUMN(A:C)<=ROW($1:$3)),CEILING($A$2:$A$4/$B$2:$B$4,1)))),$B$2:$B$4))

summer.linn

=MIN(LOOKUP(SUM($D$1:D1),SUBTOTAL(9,OFFSET($A$1,,,ROW($1:$3),)),SUBTOTAL(9,OFFSET($A$2,,,ROW($1:$3),)))-SUM($D$1:D1),LOOKUP(SUM($D$1:D1),SUBTOTAL(9,OFFSET($A$1,,,ROW($1:$3),)),B$2:$B$4))

FindingB

我走我流 发表于 2020-10-31 18:16
=IF(OR(MMULT(N(COLUMN(A:C)

用LOOKUP(……,FREQUENCY(……))这种方法，如都采用统一比率譬如6，该如何简化呢。