- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
a1=OFFSET($A$1,(ROW()-1)*4,COLUMN(A1)-1)
f1=OFFSET($A$1,ROW()*4-3,COLUMN(A1)-1)
·PÁ ANGELA ª©¤j ...
binargoo µoªí©ó 2011-7-13 11:50
a1=OFFSET(SHEET1!$A$1,(ROW()-1)*4,COLUMN(A1)-1)
A1®É ROW() ·|µ¥©ó1 ,COLUMN(A1)¤]µ¥©ó1 ©Ò¥Ha1=OFFSET(SHEET1!$A$1,0,0)
a2®É ROW() ·|µ¥©ó2,COLUMN(A2)=1 ©Ò¥Ha2=OFFSET(SHEET1!$A$1,4,0)
b1®É ROW() ·|µ¥©ó1 ,COLUMN(b1)=2©Ò¥Hb1=OFFSET(SHEET1!$A$1,0,1)
b2®É ROW() ·|µ¥©ó2,COLUMN(b2)=2 ©Ò¥Hb2=OFFSET(SHEET1!$A$1,4,1)
¨ä¾l¦P²z |
|