内存数组七之连胜进球

solextrade

今年春节不一般呀，全国人民齐心协力，众志成城，必能战胜病毒！

原计划是在正月初八上这道题目的，因情况特殊，估计有不少老师们也像我这样宅在家里吧。提前发上来，给大家解解闷了

连胜进球.rar (11 KB, 下载次数: 78)

2020-1-27 17:06 上传

点击文件名下载附件

王嘉玲

小罗哥哥基本每天都能看到，有问题也是耐心帮人解答，谢谢您。
我根据自己的理解重新写一次吧，比书上讲的难多了。
=MOD(MAX(MMULT(TRANSPOSE(IF(RIGHT(B2:B39)-LEFT(B2:B39)<0,100+LEFT(B2:B39),0)),N(MMULT(N(ROW(1:38)>=COLUMN(A:AL)),N(RIGHT(B2:B39)-LEFT(B2:B39)>=0))=COLUMN(A:AM)-1))),100)

藍色DE流光

抄一遍007版主的
=MOD(MAX(MMULT(TRANSPOSE(LEFT(B2:B39))+100,N(LOOKUP(A2:A39,ROW(1:39)/(B1:B39<RIGHT(B1:B39)&1))*(B2:B39>RIGHT(B2:B39)&1)=COLUMN(A:AL)))),100)

先整个复杂的，再来想怎么优化

1. =MOD(MAX(MMULT({100,1},MMULT(TRANSPOSE(LEFT(B2:B39))*{0;1}+{1;0},--IF(LEFT(B2:B39)>RIGHT(B2:B39),MMULT(N(ROW(2:39)>COLUMN(A:AL)),N(LEFT(B2:B39)<=RIGHT(B2:B39)))+1=COLUMN(A:AL))))),100)

复制代码

delete_007

142字：
=MOD(MAX(MMULT(TRANSPOSE(100+LEFT(B2:B39)),N(LOOKUP(A2:A39+1,ROW(1:39)/(B1:B39<RIGHT(B1:B39)&1))*(B2:B39>RIGHT(B2:B39)&1)=COLUMN(A:AL)))),100)
146字：
=MOD(MAX(MMULT(TRANSPOSE(100+LEFT(B2:B39)),N(--TEXT(LOOKUP(A2:A39+1,ROW(1:39)/(B1:B39<RIGHT(B1:B39)&1)),"[<"&A2:A39+1&"];99")=COLUMN(A:AL)))),100)
149字：
=MOD(MAX(MMULT(TRANSPOSE(100+LEFT(B2:B39)*(B2:B39>RIGHT(B2:B39)&1)),N(MMULT(N(A2:A39>=COLUMN(A:AL)),N(B2:B39<RIGHT(B2:B39)&1))=COLUMN(A:AM)-1))),100)

丢丢表格

delete_007 发表于 2020-1-27 20:17
142字：
=MOD(MAX(MMULT(TRANSPOSE(100+LEFT(B2:B39)),N(LOOKUP(A2:A39+1,ROW(1:39)/(B1:B39RIGHT(B2:B39) ...

B1 单元格“比分”两个汉字都利用上了.........  太能取巧了。

micch

提前发了哪，7版太厉害了，一下没的玩了

1. =MOD(MAX(MMULT(-(A2:A39=MATCH(COLUMN(A:AL),A2:A39/(LEFT(B1:B38)<=RIGHT(B1:B38)))),-TEXT(LEFT(B2:B39),"[>"&RIGHT(B2:B39)&"]100;\0"))),100)

复制代码

piny

=MAX(MMULT((COLUMN(A:AL)-ROW(1:38)<MAX(FREQUENCY(ROW(1:38),IF(LEFT(B2:B39)>RIGHT(B2:B39),,ROW(1:38))))-1)*(COLUMN(A:AL)>=ROW(1:38)),IF(LEFT(B2:B39)>RIGHT(B2:B39),--LEFT(B2:B39),-9^9)))

參與一下, 各位老師思路都比我短

丢丢表格

micch 发表于 2020-1-28 09:21
提前发了哪，7版太厉害了，一下没的玩了

我只会这样写：

=MOD(MAX(MMULT(N(FIND(1,CONCAT(N(B2:B39<RIGHT(B2:B39)&0))&1,COLUMN(A:AL))=ROW(1:39)),IF(B2:B39>RIGHT(B2:B39)&0,100+LEFT(B2:B39),0))),100)

micch

1. =MOD(MAX(MMULT(N(A2:A39=MATCH(COLUMN(A:AL),A2:A39/(B1:B38<=RIGHT(B1:B38)&1))),LEFT(10&B2:B39,3)*(B2:B39>RIGHT(B2:B39)&0))),100)

复制代码

文本比较，学习一下，可以少写left

象山海鲜

1. =MOD(MAX(MMULT(N(A2:A39<COLUMN(B:AM)),(A2:A39<COLUMN(B:AM))*(-9*(B2:B39<RIGHT(B2:B39)&1)&100&LEFT(B2:B39)))),500)

复制代码