【已开贴】字符争霸第12期：找数字

liyh67

Z10=OFFSET(C5,(($Z$3>5)+($Z$3=0))*6,MOD($Z$3+4,5)*4)&""

vadera

1. =OFFSET(S5:U9,((Z3-3)^2>8)*6,MOD(Z3,-5)*4)&""

复制代码

948621651

1. =INDEX((C5:U9,C11:U15),ROW(1:5),MOD(Z3-1,5)*4+{1,2,3},2^OR(Z3>5,Z3=0))&""
   
2. =OFFSET(CHOOSE(Z3+1,S11,C5,G5,K5,O5,S5,C11,G11,K11,O11),,,5,3)&""

复制代码

路边的记忆

好久不来冒泡了

区域数组

1. =OFFSET(C4:E8,7^OR(Z3>5,Z3=0),MOD(Z3-1,5)*4)&""

复制代码

ldxhzy

不算等号，用了75 个字符。重在参与！

ys19840718

来试试
z10：ab14多单元格数组公式，111字符，估计还是很长

1. =IF({1},INDIRECT(TEXT(MIN(IF(Z3&""=A1:U15&"",ROW(1:15)/1%+COLUMN(A:U)))+(ROW(1:5)-1)/1%+{0,1,2},"R00C00"),))&""

复制代码

久久久

cleverzhzhf

1. =OFFSET(C5:E9,TEXT(Z3,"[>5]6;[>0]\0;6"),MOD(Z3-1,5)*4)&""

复制代码

=IF(INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10)),INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10)))):INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10))+4,INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10))+2))="","",INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10)),INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10)))):INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10))+4,INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10))+2)))

=IF(INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10)),INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10)))):INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10))+4,INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10))+2))="","",INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10)),INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10)))):INDIRECT(ADDRESS(INDEX({5,5,5,5,5,11,11,11,11,11},IF(Z3>0,Z3,10))+4,INDEX({3,7,11,15,19,3,7,11,15,19},IF(Z3>0,Z3,10))+2)))