根据说明和要求，编写通用的函数公式

刘老三烤肉小海鲜

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

飘逝

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

素心从简

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

吴建福

感谢大佬。我验证看看。

我无敌了

=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))))

多余的我

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

朱啟

A41:A43三行的结果是1715

我的神话

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

鹰窠顶

好像类别也不多。
=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})
数组

亘古不变的恒

=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))))