骰子判斷 (10155)

E2{=CHOOSE(INT((SUM(COUNTIF(A2:C2,A2:C2))-1)/2),CHOOSE(COUNT(FIND(MID(SUM(SMALL(A2:C2,{1,2,3})*10^{2,1,0})&0,{1,2},2),12345678901920))+1,"杂六","半顺","顺子"),"对子",,"豹子")

另解{=TEXT(SUM(COUNTIF(A2:C2,A2:C2)-1),"[=2]对子;[>2]豹子;"&IF(OR(MMULT(COUNTIF(A2:C2,MOD(ROW($1:$10)-1+{0,1,2},10)),{1;1;1})=3),"顺子",IF(OR(MMULT(COUNTIF(A2:C2,MOD(ROW($1:$10)-1+{0,1},10)),{1;1})=2),"半顺","杂六")))

另解{=IFERROR(IF(ROUND(SKEW(A2:C2)^2,4)=3,"对子",CHOOSE(1+COUNT(FIND({11,111},SUM(10^ROW($1:$12)*COUNTIF(A2:C2,MID(123456789012,ROW($1:$12),1))))),"杂六","半顺","顺子")),"豹子")

另解{=CHOOSE(MAX(COUNTIF(A2:C2,A2:C2)),CHOOSE(COUNT(FIND(MID(SUM(SMALL(A2:C2,{1,2,3})*10^{2,1,0})&0,{1,2},2),12345678901920))+1,"杂六","半顺","顺子"),"对子","豹子")

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