刘老三烤肉小海鲜 发表于 2022-1-26 13:43:22

大佬编写的公式简洁明快，经过验证完全正确！高！！！

飘逝 发表于 2022-1-26 16:15:46

江山社稷大佬：如果把35个不同元素，按9、6、5、8、7的数目，依次存放在0、1、2、3、4五个分区里（即每个分区里的元素个数不尽相同），又该怎样编写通用公式？

素心从简 发表于 2022-1-26 16:51:02

=PRODUCT(COMBIN({9,6,5,8,7},LEN(A5)-LEN(SUBSTITUTE(A5,{0,1,2,3,4},))))
是这个意思么？？

吴建福 发表于 2022-1-28 18:48:34

感谢大佬。我验证看看。

我无敌了 发表于 2022-1-30 14:25:49

=COMBIN(7,(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))*IF((SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1)<2,COMBIN(7,(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))),IF((SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1)=(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",)))),7^(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",)))),COMBIN(7,(SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1))*7^((LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))-(SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1))))

多余的我 发表于 2022-2-1 13:02:35

A61:A62三行的结果应该是1715， A76:A78三行的结果应该是245，A79的11122的结果应该是735......还有多处错误。

朱啟 发表于 2022-2-2 07:49:00

A41:A43三行的结果是1715

我的神话 发表于 2022-2-4 21:11:34

实在没办法了，找vba大神或者穷举高手

鹰窠顶 发表于 2022-2-6 04:39:12

好像类别也不多。
=LOOKUP(SUM(N(MID(A5,ROW($1:$5),1)=TRANSPOSE(MID(A5,ROW($1:$5),1)))),{5,7,9,11,13,17,25},{16807,7203,3087,1715,735,245,21})
数组

亘古不变的恒 发表于 2022-2-16 06:53:01

=COMBIN(7,(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))*IF((SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1)<2,COMBIN(7,(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))),IF((SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1)=(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",)))),7^(LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",)))),COMBIN(7,(SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1))*7^((LEN(A5)-(LEN(A5)-LEN(SUBSTITUTE(A5,"0",))))-(SUMPRODUCT(N(FIND(MID(A5,ROW($1:$5000),1),A5)=ROW($1:$5000)))-1))))
页: 1 [2] 3 4
查看完整版本: 根据说明和要求，编写通用的函数公式