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

[µo°Ý] ½Ð°Ý¤@­Ó»P¤u§@ªí¦WºÙ¬ÛÃöªº°ÝÃD

[µo°Ý] ½Ð°Ý¤@­Ó»P¤u§@ªí¦WºÙ¬ÛÃöªº°ÝÃD

¤p§Ì°ÝÃD¤£®e©ö¤f­z,¤W¶ÇÀɮ׷ниô¹Lªº¤j Book1.rar (2.28 KB) ¤j­Ì«ü¾É!!

¦^´_ 1# sujane0701


    A1=INDIRECT("'"&ROW()&"'!R"&COLUMN()&"C1",0)
¦V¥k¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ÁÂÁª©¥D¦Ñ®v«ü¾É~«D±`·P¿E!!

TOP

¦^´_ 3# sujane0701


¦A¦¸½Ð±ÐHsieh¦Ñ®v
­ì¥»±z«ü¾É«á¤p§Ìı±oÀ³¸Ó¥i¥H¦Û¦æ¸Ñ¨M¤u§@¤Wªº§xÃø,¦ý¬Oµo²{¦Û¤w°ò¦¤Ó²LÁ¡,®Ú¥»µL¤O¸Ñ¨M°ÝÃD,¥u¦n¦A¨Ó°Q±Ï§L><
201006.rar (19.03 KB)
³o¬O¤p§Ì¤u§@¤W¤½¥q³]©w¦nªºªí³æ
¨ä¤¤
C3 D3 E3 F3 ¥|­ÓÀx¦s®æ¤½¦¡ À³¦p¦ó³]©w
¤~¥i¥H¹F¨ì¤U¦C¥Øªº?

1.B3Äæ¤é´ÁÅܧó,´N·|¦Û°Ê¨ì¬ÛÀ³¤u§@ªíÂ^¨ú¼Æ­È?
2.¥u»Ý³]©wC3 D3 E3 F3¤@¦¸,§Y¥i¥H©¹¤U«þ¨©¤½¦¡?

½Ð¸ô¹Lªº¤j¤j­Ì¤£§[«ü¾É
(³o¬O¤½¥q¨î¦¡®æ¦¡,¤p§Ì¤]ı±o±N¾ã¤ë¥÷¸ê®Æ¥þÀ½¦b¤@°_,¨Ã¥B¥H¤é´Á¤À¦¨¤£¦Pªí³æ·Pı«Ü¤£¤è«K,¦ý¬OµLÅv§ïÅÜ~~¥u¦n½Ð°ª¤â¤j¤j­ÌÀ°À°¤p§Ì)

TOP

¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2010-5-26 19:41 ½s¿è

Excel¤£¬OWord,¤@­Ó¤ë³Ì¦h«Ø¥ß31±iA4¤j¤p¤§¤u§@ªí,´N·Q¬d¸ß²Î­p?

µª®×¬O«Ø¥ß¸ê®Æ®w

¤é³øªí¨C¤é­n¼g¤J¸ê®Æ®wÀx¦s
¦Ó«D«Ø¥ß¤@°ï¤é³øªí

TOP

¦^´_  sujane0701


¦A¦¸½Ð±ÐHsieh¦Ñ®v
­ì¥»±z«ü¾É«á¤p§Ìı±oÀ³¸Ó¥i¥H¦Û¦æ¸Ñ¨M¤u§@¤Wªº§xÃø,¦ý¬Oµo²{¦Û ...
sujane0701 µoªí©ó 2010-5-26 03:00


¸Õ¤@¸Õ¬O³o·N«ä¶Ü ?

201006.rar (20.27 KB)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# zz5151353


·PÁÂzz5151353 ª©¥D¤j¤j,³o¥¿¬O¤p§Ìªº»Ý¨D!!¦A¤T·PÁÂ~

¥t¥~¤]·PÁ¦ѮL¦Ñ®v»¡©ú,½T¹êªí³æ³]­pªº²z©À¤£¦n,­l¥Í¥X¨Óªº¦UºØ°ÝÃD«Ü¦h,¥u¬OµL©`¤p§Ì¥u¬O¤½¥q¥|¸U¦h°ò¼h¤p¾­û¤¤ªº¤@­û,³s«Øijªº¾÷·|¤]¨S¦³,§ó¤£¥Î»¡­×§ïÅv¤F,¦ý¬O¤S¥²¶·­±¹ï,¥u¦n®³³oºØ²Â°ÝÃD¥X¨Ó¥´ÂZ¤j®a.

³Ì«á¤p§Ì¦³­ÓºÃ´b·Q½Ð±Ð
=SUM(INDIRECT(DAY($B3)&"!R2C[1]:R106C[1]",))
¤½¦¡¤¤ "!R2C[1]:R106C[1]"  ­n«ç»ò¸ÑŪ®º?
R¬O§i¶D¤½¦¡ «á­±ªº­ÈR1C1ªºÄæ¦W¦C¸¹ªí¥Üªk¶Ü?
2C[1]¤¤ªº2C¬OÀ³¸Ó«ç»ò»P±`¨£ªºA1,B2ªºªí¥Üªk´«ºâ? ©Î¬OÀ³¦p¦ó¸ÑŪ³o¦ê¦ì§}ªí¥Üªk?

¤p§Ì°ò¦¤£¦n,­Y¥i¥H,ÁٽЪ©¥D©Î¸ô¹Lªº¤j¤j­Ì«üÂI°g¬z~
³Ì«á·q¯¬¦U¦ì¤j¤j ¨­¤ß´r§Ö,°·±d

TOP

R2C[1]¬O«ü²Ä2¦C¤¤(µ´¹ï°Ñ·Ó),»P§@¥ÎÀx¦s®æ¬Û¹ï1Äæ
¦p¤½¦¡¼g¦bC2Àx¦s®æ
=R2C[1]
´N¸ò=D$2¬O¬Û¦P·N¸q
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh


¦A¦¸·PÁ Hsieh ¦Ñ®v«ü¾É,§ó·PÁ±zªº­@¤ß,¤p§Ì¦Ûª¾¨C¦¸µo°Ýªº°ÝÃD»á¬°²LÁ¡¥i¯º,¦ý¬O±z¤´µM­@¤ß«üÂI,¯uªº¤Q¤À·PÁÂ!!

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD