°lÂܱqÄÝ°Ñ·Óªºbug?(¤½¦¡¦³¸ósheet³sµ²Àx¦s®æ»Poffset)
- ©«¤l
- 41
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 83
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-20
- ³Ì«áµn¿ý
- 2019-12-17
|
°lÂܱqÄÝ°Ñ·Óªºbug?(¤½¦¡¦³¸ósheet³sµ²Àx¦s®æ»Poffset)
sheet1[A1]=Sheet2!A1+OFFSET(B1,0,1)
sheet1[A2]=B2+OFFSET(B1,0,1)
¦bSheet2[A1]«ö°lÂܱqÄÝ°Ñ·Ó·|Åã¥Ü
Sheet1[B2]«ö°lÂܱqÄÝ°Ñ·Ó«h¥i¥¿±`«ü¦VA2
¸Õ¹L2003»P2007ª©³£¦³¬Û¦P±¡§Î...´ú¸ÕÀɮצpªþ¥ó |
-
-
test.rar
(1.32 KB)
|
|
|
|
|
|