[开_150]斗牛游戏[已总结]

笑眼晴天

1. =IF(COUNT(SEARCH("3?0",MMULT((A2:E2<=9)*A2:E2+100,-(MOD(COLUMN(1:1)/2^ROW($1:$5),2)<1)))),TEXT(RIGHT(SUM((A2:E2<=9)*A2:E2)),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

wangg913

凑一个。组合

1. =IFERROR(TEXT(MOD(1&-3&MAX(-RIGHT(MMULT((A2:E2<10)*A2:E2,100^MID(0&111001110101101,TEXT(COLUMN(A:K),"[=6]5")+ROW($1:$5),1)),3))-10,10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

MUNIT 是2013版函数。不用组合

1. =IFERROR(TEXT(MOD(3&-3&MAX(IF(MUNIT(5)=0,-RIGHT(SUM((A2:E2<10)*A2:E2)/1%-((A2:E2<10)*A2:E2+TRANSPOSE((A2:E2<10)*A2:E2))*99,3)))-10,10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

1. =IFERROR(TEXT(RIGHT(10^(2&MIN(IF(MUNIT(5)=0,MOD(SUM((A2:E2<10)*A2:E2)/1%-((A2:E2<10)*A2:E2+TRANSPOSE((A2:E2<10)*A2:E2))*99,1000))))),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

IFNA 是2013的函数，否则改为 IFERROR。还是组合

1. =IFNA(TEXT(HLOOKUP("3?0*",MID(MMULT(100+(A2:E2<10)*A2:E2,1000^INT(MOD(COLUMN(A:AC)/2^ROW($1:$5)*2,2)))&"",{1;6},{6;1}),2,),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

再减

1. =IFNA(TEXT(RIGHT(HLOOKUP("3?0*",""&MMULT(100+(A2:E2<10)*A2:E2,1000^ISODD(COLUMN(N:BD)/2^ROW($1:$5))),1,)),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

COLUMN(N:BD) 改成 COLUMN(1:1) ，还能减一个字，就是慢很多。

唐伯狼

1. 
   

复制代码

1. =IF(SMALL(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0"))-SMALL(IF(ROW($1:$5)<>COLUMN(A:E),1*TEXT(A2:E2,"[>10]1!0")+TRANSPOSE(1*TEXT(A2:E2,"[>10]1!0"))),ROW($1:$10)*2),10),1)=0,TEXT(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0")),10),"0点;;牛"), LARGE(A2:E2,1)&"大")

复制代码

235个字符

1. =IF(MIN(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0"))-SMALL(IF(ROW($1:$5)<>COLUMN(A:E),1*TEXT(A2:E2,"[>10]1!0")+TRANSPOSE(1*TEXT(A2:E2,"[>10]1!0"))),ROW($1:$10)*2),10))=0,TEXT(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0")),10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

226字符  思路不对

1. =IF(MIN(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0"))-SMALL((ROW(1:5)<>COLUMN(A:E))*(TEXT(A2:E2,"[>10]1!0")+TRANSPOSE(TEXT(A2:E2,"[>10]1!0"))),ROW($1:$10)*2),10))=0,TEXT(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0")),10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

220

1. =IF(MIN(MOD(SUM(IF(A2:E2>10,10,A2:E2))-SMALL(IF(ROW($1:$5)<>COLUMN(A:E),IF(A2:E2>10,10,A2:E2)+TRANSPOSE(IF(A2:E2>10,10,A2:E2))),ROW($1:$10)*2),10))=0,TEXT(MOD(SUM(IF(A2:E2>10,10,A2:E2)),10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

214



思路二。  不让用不连续的手工数组，连续的总可以用吧。不可以把{4,3,2,1,0}换成(5-COLUMN(A:E))

1. =IF(MIN(MOD(LARGE(MMULT(MOD(INT(ROW($1:$31)/2^{4,3,2,1,0}),2)*(MMULT(MOD(INT((ROW($1:$31))/2^{4,3,2,1,0}),2),ROW($1:$5)^0)=3),SMALL(--TEXT(A2:E2,"[>10]1!0"),ROW($1:$5))),ROW($1:$10)),10))=0,TEXT(MOD(SUM(1*TEXT(A2:E2,"[>10]1!0")),10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

257个字符

soar.xiaolei

1. =IF(AND(MOD(SUM(IF(A2:E2>10,10,A2:E2))-IF(ROW($1:$5)<>COLUMN(A:E),IF(A2:E2>10,10,A2:E2)+TRANSPOSE(IF(A2:E2>10,10,A2:E2)),0.1),10)),MAX(A2:E2)&"大",TEXT(-RIGHT(SUM(IF(A2:E2>10,10,A2:E2))),"牛;0点"))

复制代码

chunlin1wang

勉强达到148字符

1. =IFERROR(TEXT(RIGHT(SUMIF(A2:E2,"<11")/OR(MOD(MMULT((A2:E2<11)*A2:E2*10+1,MOD(INT(COLUMN(A:AF)/2^ROW($1:$5)*2),2)),100)=3)),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

03版 152
=TEXT(-1^OR(MOD(MMULT((A2:E2<11)*A2:E2*10+1,MOD(INT(COLUMN(A:AF)/2^ROW($1:$5)*2),2)),100)=3)*RIGHT(SUMIF(A2:E2,"<11")),TEXT(MAX(A2:E2),"#\\#")&"大;0点;牛")

CY7CY7CY7

1. =IF(MIN(MOD(IF({1;2;3;4}={2,3,4,5},9,SUMIF(A2:E2,"<10")-(B2:E2<10)*B2:E2-TRANSPOSE((A2:D2<10)*A2:D2)),10)),MAX(A2:E2)&"大",TEXT(-RIGHT(SUMIF(A2:E2,"<10")),"牛;0点"))

复制代码

数组

cl63519

一法：=TEXT(IFERROR(LOOKUP(10,TEXT(RIGHT(MMULT(TEXT(N(OFFSET(A2,,MID({12;13;14;15;23;24;25;34;35},{1,2},1)-1)),"[>10]!0")*1,{1;1})),"[="&RIGHT(SUM(IF(A2:E2>10,,A2:E2)))&"]0;")*1),MAX(A2:E2)&"大"),"0点;;牛")

贰法：=TEXT(IFERROR(LOOKUP(,-TEXT(RIGHT(LARGE((IF(A2:E2>10,,A2:E2)+TRANSPOSE(IF(A2:E2>10,,A2:E2)))*(ROW($1:$5)>{1,2,3,4,5}),ROW($1:$10))),"[="&RIGHT(SUM(IF(A2:E2>10,,A2:E2)))&"]0;")),MAX(A2:E2)&"大"),";0点;牛")；

三法：

1. =TEXT(IFERROR(LOOKUP(,(MATCH(MOD(SUM(A2:E2*(A2:E2<10))-A2:E2*(A2:E2<10),10),IF(A2:E2>9,,A2:E2),)<>{1,2,3,4,5})^0*-RIGHT(SUM(A2:E2*(A2:E2<10)))),MAX(A2:E2)&"大"),";0点;牛")

复制代码

hsw212

1. =IFERROR(TEXT(RIGHT(SUM(IF(A2:E2>9,,A2:E2)*(1-MID(DEC2BIN(TEXT(MAX(IF(MOD(TEXT(MMULT(IF(A2:E2>9,,A2:E2)%+1,--MID(DEC2BIN(COLUMN(A:AE),5),ROW($1:$5),1)),"[>4]1%;[<3]1%;.00")/1%,10),,COLUMN(A:AE))),"0;;"),5),COLUMN(A:E),1)))),"#点;;牛"),MAX(A2:E2)&"大")

复制代码

拼了老命搞才到250以下，过段时间忙了也没事研究了。发上来参与一下吧。

笨笨四

1. =IF(COUNT(0/(MATCH(MOD(SUMIF(A2:E2,"<10")-(A2:E2<10)*A2:E2,10),(A2:E2<10)*A2:E2,)-COLUMN(A:E))),TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

zigbeeww

1. =IF(OR(MOD(MMULT(IF(A2:E2>=10,,A2:E2),-MID(MID(111001110101101,COLUMN(A:J)+INT(COLUMN(A:J)/6),5),ROW($1:$5),1)),10)=0),TEXT(MOD(SUM(IF(A2:E2>=10,,A2:E2)),10),"[>0]0点;牛"),MAX(A2:E2)&"大")

复制代码

185字符,不知道算不算,来学习了