- 第一题
- ={"","","","",1,3,5;7,9,11,13,15,17,19;21,23,25,27,29,31,33;35,37,39,41,43,45,47;49,51,53,"","","",""}
- 图一及图二
- =ROW(1:3)*3+COLUMN(A:C)-3
- =COLUMN(A1)+(ROW(A1)-1)*3
- =(ROW(1:3)-1)*3+COLUMN(A:C)
- =ROW()*3+COLUMN()-27
- =3*ROW(1:3)-{2,1,0}
- 图三
- =ROW($A$3)/3
- =COLUMN($C$1)/3
- 图四
- =ROW(1:3)*3-3+COLUMN(1:3)
- =3*ROW(1:3)-{2,1,0}数组公式
- 图五
- =COLUMN(A1)
复制代码 |