¸óÀÉ : ¥ÎINDIRECTŪÀx¦s®æ¤º®e¡A¬°¤°»ò¸ê®ÆÀÉn¦P¨B¶}±Ò?
- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-15
- ³Ì«áµn¿ý
- 2018-10-16
|
¸óÀÉ : ¥ÎINDIRECTŪÀx¦s®æ¤º®e¡A¬°¤°»ò¸ê®ÆÀÉn¦P¨B¶}±Ò?
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# u7490074
¦³2ÓÀɮסG¡idataÀÉ¡j / ¡iŪ¨úÀÉ¡j
¥dÃö°ÝÃD¡G¡iŪ¨úÀÉ¡jŪ¨ú¸ê®Æ®É¡A¹J¨ì¤U¦C°ÝÃD¡A½Ð°Ý¬O§_¦³¤è¦¡¥i¸Ñ(EXCELÀɮפ¤)
(1)¡idataÀÉ¡j»Ý¦P®É¶}µÛ¡A¤£µMµLªkŪ¨ú¸ê®Æ·|¥X²{#REF!
(2)Àx¦sÄæ¡G¶·¤À¤ë§ó°Ê(©¹¥k²¾)¡A¬O§_¦³¬Y°Ñ¼Æ¥i¥H¨C¤ë¤U¤@¦¸¬ÛÃöÈ´N¥i¦P¨B§ó°Ê(¦p¡G¿é¤J2¡A¥Nªí2¤ë¡AA1´N·|ÅÜB1)
(3)¨ç¼Æ¡G=INDIRECT("'"&B1&"["&B2&"]"&B3&"'!"&B4)........¬O§_¥i¥H¤£¶}¡idataÀÉ¡j´N¯à¦b¡iŪ¨úÀÉ¡j¨ú±o¸ê®Æ©O?
¨Ï¥Î INDIRECT ¨ç¼Æ½T¹ê¦³¦¹¨î¡A¸óÀɮɥ²¶·ÀÉ®×»Ýn¦P®É¥´¶}¤~¯à¨úªº¸ê®Æ
¤£¶}ÀɮרúªºÀx¦s®æ¸ê®Æ¥Ø«e¥u¯à¿é¤J '¸ô®|\[ÀɦW]SheetName'!Àx¦s®æ
©Ò¥H¥i¥H¥Î¥b¤H¤u¤è¦¡
B5 ="='"&B1&"["&B2&"]"&B3&"'!"&B4
½Æ»sB5¡AB6¿ï¾Ü©Ê¶K¤W - È¡A¦A½s¿èENTER¤@¦¸´NÅܦ¨¤½¦¡
³o´N¯àª½±µ¨úªº |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|