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

砂海

占楼
=OFFSET(B4,1+6*OR($Z$3>5,$Z$3=0),(4*IF(MOD($Z$3,5),MOD($Z$3,5),5))-3)&""

非引用
=INDEX(IF(INT(MOD(INDEX({25746,29671,29647,23497,31183,31215,29330,31727,31695,31599},IF($Z$3,$Z$3,10)),2^(16-ROW($1:$15)))/2^(15-ROW($1:$15))),$Z$3,""),3*(ROW()-10)+COLUMN()-25)

=INDEX(IF(INT(MOD(INDEX({1168,7021,3096,3120,9270,1584,1552,3437,1040,1072},$Z$3+1),2^(16-ROW($1:$15)))/2^(15-ROW($1:$15))),"",$Z$3),3*(ROW()-10)+COLUMN()-25)

风林火山

1. =OFFSET(C5,(MOD(Z3+9,10)>4)*6,MOD(Z3+9,5)*4,5,3)&""

复制代码

chunlin1wang

1. =OFFSET(C5:E9,INT(Z3/6+(Z3=0))*6,MOD(Z3-1,5)*4)&""

复制代码

huangcaiguang

区域数组

1. =TRIM(MID("0000 00 00 000011  1  1  1  1 222  22222  222333  3333  33334 44 4444  4  45555  555  55556666  6666 6666777  7 7  7  7 8888 88888 88889999 9999  9999",ROW()*3+COLUMN()-55+Z3*15,1))

复制代码

=OFFSET(C5:E9,6*((Z3-3)^2>8),MOD(Z3-1,5)*4)&""
收山

chensir

=CHOOSE($Z$3+1,IF(S11:U15="","",S11:U15),IF(C5:E9="","",C5:E9),IF(G5:I9="","",G5:I9),IF(K5:M9="","",K5:M9),IF(O5:Q9="","",O5:Q9),IF(S5:U9="","",S5:U9),IF(C11:E15="","",C11:E15),IF(G11:I15="","",G11:I15),IF(K11:M15="","",K11:M15),IF(O11:Q15="","",O11:Q15))

ddmyykdzh

1. OFFSET(A1,IF(Z3=0,11,IF(Z3<6,5,11))-1,IFERROR(MATCH(Z3,C5:U5,),MATCH(Z3,C11:U11,))+1,5,3)&""

复制代码

江河行地

=LEFT(OFFSET(INDIRECT(TEXT(MIN(IF((B5:U15=Z3)*(B5:U15<""),ROW(5:15)/1%+COLUMN(B:U))),"r0c00"),),,,5,3))

526753064

1. =OFFSET(U10,IF(AND(Z3>0,Z3<6),-5,1),-4*MOD(10-Z3,5),5,-3)&""

复制代码

1091126096

公式2，46字符。

1. =OFFSET(C5,6*OR(Z3>5,Z3=0),MOD(Z3-1,5)*4,5,3)&""
   
2. =OFFSET(C5:E9,(6*Z3<=Z3^2)*6,MOD(Z3-1,5)*4)&""

复制代码

kuangben8

Z10：AB14区域数组公式：

1. =OFFSET(C5,((Z3>5)+(Z3=0))*6,MOD(Z3-1,5)*4,5,3)&""

复制代码

修改一下

1. =OFFSET(C5:E9,OR(Z3>5,Z3=0)*6,MOD(Z3-1,5)*4)&""

复制代码