- ©«¤l
- 72
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 126
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-4-2
- ³Ì«áµn¿ý
- 2016-1-14
|
¥»©«³Ì«á¥Ñ jimmuLu ©ó 2011-5-13 10:28 ½s¿è
¦^´_ 18# yanto913
Hello¡A§Ú¤]¦³³oÓ°ÝÃD¡AHsieh¤w¸g´£¥Ü¤F¡A
¨ç¦¡¨S°ÝÃD¡A§Ú¥h¬Ý¤F»¡©ú¡Aì¨Ó¬O§Ų́Sª`·N¡AÀ³¸Ó¥ý¶}°Ñ¦ÒÀÉ«á¦A¶}®Ñ¼g¨ç¦¡¨ºÓÀÉ´N¥i¥H¬Ý¨ì¤F¡C
PS:¤]´N¬O¥ý¶}2.xls¡A¦A¶}1.xls
»yªk
INDIRECT(ref_text,a1)
Ref_text ¬OÓ³æ¤@Àx¦s®æªº°Ñ·Ó¦ì§}¡F¦Ó³oÓÀx¦s®æ§t¦³¨Ì A1 ®æ¦¡©Î R1C1 ®æ¦¡©Ò«ü©wªº°Ñ·Ó¦ì§}¡B¤@Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦WºÙ©Î¬O¤@Ó©w¸q¬°°Ñ·Ó¦ì§}ªº¦r¦ê¡C¦pªG ref_text ¤£¬O¤@Ó¦³®ÄªºÀx¦s®æ¦ì§}¡A«h INDIRECT ¶Ç¦^¿ù»~È #REF!¡C
¦pªG ref_text «ü¦V¥t¤@Ó¬¡¶Ã¯ (¥~³¡°Ñ·Ó)¡A«h¨ºÓ¬¡¶Ã¯¥²¶·¤w¸g¬O¶}±Òªº¡A§_«h INDIRECT ¶Ç¦^¿ù»~È #REF!¡C |
|