- ©«¤l
- 759
- ¥DÃD
- 249
- ºëµØ
- 0
- ¿n¤À
- 1021
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 11
- ³nÅ骩¥»
- OFFICE2021
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-5-30
- ³Ì«áµn¿ý
- 2024-11-10
|
¥»©«³Ì«á¥Ñ t8899 ©ó 2013-3-27 05:58 ½s¿è
¦^´_ t8899
INDIRECT¨ç¼Æ°Ñ·Ó¥~³¡ÀɮסA¸ÓÀÉ®×¥²¶·¬°¶}±Òª¬ºA¤è¥i°Ñ·Ó
§A¤½¦¡¤¤ªºaa46¬OÀx¦s®æ°Ñ·Ó©Î ...
Hsieh µoªí©ó 2013-3-26 23:05
§Ú¥Ø«e¥Î ='V:\program\supertsc\[indirect(aa46).xls]She5555555555555et6'!$H$2 ¬O¥i¥Hªº¡A¦ý©ì¦²¤£·|¦Û°Ê§ïÅÜ°Ñ·ÓÈ
§ï¦¨ ='V:\program\supertsc\[indirect("aa"&ROW(aA46)).xls]She5555555555555et6'!$H$2 ¥X²{#REF!
§Úªºaa46 ¬° =IF(A46="","",TEXT(INDIRECT("a"&ROW(A46)),"EMMDD")) ===>a46¬°¤é´Á®æ¦¡
emmdd (¥i¥H©ì¦²)
쥻¬O§â³o¨âÓ¼g¦¨¤@Ó¡A¦n¹³¤£¦æ¡A´N©î¶} |
|