ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦U¦ì¥Îexcelªº°ª¤â­Ì!¦p¦ó¦¬´M«ü©wÀx¦s®æ¦ì¸mªº¸ô®|ÀÉ®×"¨ç¼Æ­n¦p¦ó³]

¥»©«³Ì«á¥Ñ jimmuLu ©ó 2011-5-12 11:16 ½s¿è

¦^´_ 7# Hsieh


    ª©¤j

§Ú¨Ì·Ó¨ç¦¡¥h¼g¡A¦n¹³¦æ¤£³q¡A·Ð½ÐÀ˵ø¤@¤U¡A·PÁÂÅo



¦n¹³¬O®t¤F  '    §a

!XLS¸ê®Æ§¨.zip (9.58 KB)

TOP

¥»©«³Ì«á¥Ñ 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

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD