大神们，这种能写公式吗

说逻辑

贪吃蛇？？？？！

=TOCOL(CHOOSECOLS(WRAPROWS(TOCOL(HSTACK(A1:A15,D1:D15)),4),{1,2,4,3}),3)

=OFFSET($A$817,INT(ROW(A2)/2)-1,INT(ROW(A1)/2)-2*(INT(ROW(A5)/4)-1))硬凑

=OFFSET($A$1,ROW(A1)/2-0.5,ISODD(ROW(A1)*0.5))

=index(a:b,int(row(a2)/2),1+(mod(row(a1),4)>1))

D1=index(($a$2:$a$101,$d$2:$d$101),int(row()/2),,2-(or(mod(row(),4)={1,2})))

感谢各位大佬们

厉害👍🏻

害怕

6啊

除2取余？

下载贴吧APP
看高清直播、视频！

分享到: