骰子点数计算

sayhi95

1. =LOOKUP(,-FIND({1,3,2,11,111,"0000000"},CONCAT(FREQUENCY(MOD(A2:C2-1,10),ROW($1:$9)-1))),{"杂六","豹子","对子","半顺","顺子","顺子"})

复制代码

用了CONCAT四不像

dim麻辣君

审核还没出来，再砍一下

1. =CHOOSE(MAX(COUNTIF(A2:C2,A2:C2)),TEXT(MAX(1,SUM(N(MMULT({1,1},COUNTIF(A2:C2,MOD(A2:C2+{1;-1},10)))>0)))-2,"顺子;杂六;半顺"),"对子","豹子")

复制代码

tchh666

1. =TEXT(SUM(COUNTIF(A2:C2,A2:C2)),"[=5]对子;[>5]豹子;"&TEXT(MAX(FREQUENCY(ROW(1:13),(COUNTIF(A2:C2,MOD(ROW($1:$12),10))<>1)*ROW(1:12))-1),"[=2]半顺;[=3]顺子;杂六"))

复制代码

sayhi95

1. =LOOKUP(,-FIND({1,11,"0000000",3,2,111},TEXT(MID(SUM(FREQUENCY(MOD(A2:C2-1,10),ROW($1:$9)-1)*10^-ROW($1:$10)),3,10),REPT(0,10))),{"杂六","半顺","顺子","豹子","对子","顺子"})

复制代码

再凑个低版本的吧

jivy1212

1. =IFNA(LOOKUP(1,-FIND({11;2;111;3},SUM(10^MOD(A2:C2+1,10))),{"半顺";"对子";"顺子";"豹子"}),"杂六")

复制代码

答案对上了，没细验证

jivy1212

1. =MID("杂六半顺对子顺子豹子",MATCH(9,FIND({1;11;2;111;3},SUM(10^MOD(A2:C2+1,10))))*2-1,2)

复制代码

sayhi95

jivy1212 发表于 2022-6-21 08:16

太帅了！可惜女票不会回头给老师补花

jivy1212

sayhi95 发表于 2022-6-21 08:41
太帅了！可惜女票不会回头给老师补花

1. =MID("杂六半顺对子顺子顺子豹子",MATCH(9,FIND({1;11;2;111;1000000011;3},SUM(10^MOD(A2:C2+1,10))))*2-1,2)

复制代码

全部帖子看了下，发现还有个890不符合，模拟里没的。。所以还得加长

dim麻辣君

jivy1212 发表于 2022-6-21 08:51
全部帖子看了下，发现还有个890不符合，模拟里没的。。所以还得加长

啊这，太猛了，又是个数学界王者，老师没花了回头给您补上

sucx007

拼凑下
=MID("杂六对子豹子半顺顺子",MATCH(,-FIND({1,2,3,11,111},concat(FREQUENCY(A2:C2+{1;11},ROW($1:$20)))))*2-1,2)
=LOOKUP(,-FIND({1,2,11,111,"0000000",3},SUM(10^MOD(A2:C2+1,10))),{"杂六","对子","半顺","顺子","顺子","豹子"})