【习题】不要靠近我

lfspecter

两头雾水，坐等教程

新手路上

liu2336904 发表于 2019-8-5 17:23
要下班了老师搞偷袭，明天再看，哈哈
不限字数，我先来个搞笑的，在研究下，哈哈
=SUBSTITUTE(SUBSTITUTE ...

  ~~~咳咳~~~

solextrade

估计自己的思路不对，只想出第二题，我的公式争取搞个字符数量第一，517！
第一题再想想。

=INDEX(SUBSTITUTE(SUBSTITUTE(A4,REPT(0,ROW($1:$19))&" "," ")," "&REPT(0,COLUMN(A:S))," "),CEILING(MATCH(1,FREQUENCY(MIN(LEN(SUBSTITUTE(SUBSTITUTE(A4,REPT(0,ROW($1:$19))&" "," ")," "&REPT(0,COLUMN(A:S))," "))),LEN(SUBSTITUTE(SUBSTITUTE(A4,REPT(0,ROW($1:$19))&" "," ")," "&REPT(0,COLUMN(A:S))," "))),)/19,1),MOD(MATCH(1,FREQUENCY(MIN(LEN(SUBSTITUTE(SUBSTITUTE(A4,REPT(0,ROW($1:$19))&" "," ")," "&REPT(0,COLUMN(A:S))," "))),LEN(SUBSTITUTE(SUBSTITUTE(A4,REPT(0,ROW($1:$19))&" "," ")," "&REPT(0,COLUMN(A:S))," "))),),19))

solextrade

新手路上 发表于 2019-8-6 09:15
那个有001,0001,00000000000000000000000000001的话你这穷举法貌似不行吧，你还是乖乖的去学习FILT ...

小妹的想法可不一定对哈，现在还有不少坛友的电脑不能用FILTERXML，假如此题必须使用FILTERXML函数的话，那就是明摆着欺负人了。估计海版的题目肯定有别的路子，只是这层窗户纸还没有捅破，外面的风景还看不到。

liu2336904

静看流年RSSQ 发表于 2019-8-6 09:05
我昨晚上也是这样强写，结果自己把自己绕晕了，发现这个写法只是就题而题。最终放弃了。

比如：“1    ...

哈哈，所以说是搞笑的啊，比较暴力的方法
把(A4,"10","1"),"01","1"),"1 ","1")," 1","1")不断循环替换。。。

liu2336904

新手路上 发表于 2019-8-6 09:15
那个有001,0001,00000000000000000000000000001的话你这穷举法貌似不行吧，你还是乖乖的去学习FILT ...

纯属搞笑，哈哈^_^

慢慢学习吧，连陈老师您的组合因子都还没学习完呢！φ(≧ω≦*)♪

sayhi95

第一题，A2违章建筑...

1. =IF(RIGHT(IF(A$2>1,D4,))="1",IF(A$2>1,D4,)&IF(MID(A4,A$2,1)<"1","",MID(A4,A$2,1)),IF(AND(RIGHT(IF(A$2>1,D4,)&MID(A4,A$2,1))<"1",IFERROR(MID(A4,A$2+MATCH(1=1,MID(A4,ROW(INDIRECT(A$2&":99")),1)>"0",)-1,1),"")="1"),IF(A$2>1,D4,)&"",IF(A$2>1,D4,)&MID(A4,A$2,1)))

复制代码

循环引用

sayhi95

sayhi95 发表于 2019-8-6 10:02
第一题，A2违章建筑...循环引用

就是因为替换N次麻烦才迭代嘛，主要是想不到别的，哈哈~

sbdk007

各位大神都还没想出好办法，别急，我先攒点花

象山海鲜

sayhi95 发表于 2019-8-6 10:43
就是因为替换N次麻烦才迭代嘛，主要是想不到别的，哈哈~

自动 迭代100次
A2

1. =MOD(A2+1,100)

复制代码

D4

1. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(A$2=1,A4,D4),"1 ",1),10,1),0&1,1)," 1",1)

复制代码