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

¸ê®Æµ§¼Æ¤Ó¦hªº°ÝÃD

¸ê®Æµ§¼Æ¤Ó¦hªº°ÝÃD

½Ð°Ý°ª¤â¡G¦pªG¸ê®Æµ§¼Æ¤Ó¦h¡A¨Ò¦p¤w¸g¨ì¤F1000¦C¥H¤W¡A
­n§ä¨ì¤U¤@µ§¸ê®Æ¿é¤J¦C³q±`­n®ö¶O¤@ÂI®É¶¡¡A
¤£ª¾¹D¯à§_¦³¿ìªk¦b·Ç³Æ¿é¤J¸ê®Æ®É¡A
¤@¤U´Nª½±µ¨ì¤U¤@µ§¸ê®Æ¿é¤Jªº¥¿½T¦ì¸m¡A
©Î¬O¦³¿ìªk¦b©T©w¤@­Ó¦a¤è¿é¤J¸ê®Æ¡A
¨Ò¦p²Ä2¦C¡A¦Ó¿é¤Jªº¸ê®Æ¥i¥H¦Û°Ê¶]¨ì¥¿½T¦ì¸m¡A
½Ð°ª¤âÀ°¦£¬Ý¬Ý¡A·P®¦¡I

      A        B        C        D        E
5   ®Ñ¦W   ¤ÀÃþ  ³æ»ù   ¼Æ¶q   ³Æµù
6
7
8
9

¦ü¥G¤£»Ý­n³Â·Ðªº¤½¦¡©ÎVBA®@,EXCEL¦³¤@­Ó§Ö±¶Áä «öCTRÁä+¤è¦VÁä¤W¤U¥ª¥k,¥i¥H§ä¨ì¤W¤U¥ª¥kªº³Ì«á¤@­ÓÀx¦s®æ,¸Õ¸Õ¬Ý§a!~

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-1-21 16:21 ½s¿è

¦^´_ 1# dondon1495
§Q¥Î©w¸q¦WºÙ
1.¿ï¨úA1
2.´¡¤J/©w¸q/¦WºÙ
³]¦WºÙ¬°x
°Ñ·Ó¨ì¤½¦¡:=OFFSET(Sheet1!A$1,IF(COUNTA(Sheet1!A:A)=0,0,MAX(IF(Sheet1!A$2:A$65536<>"",ROW(Sheet1!$2:$65536),""))),0)

3.¦b¥ª¤W¨¤¦WºÙ¤è¶ô¿é¤Jx

¦s¦¨½d¥»¡A¥u­n´¡¤J¦¹½d¥»¡A¨º­Ó¬¡­¶Ã¯ªº©Ò¦³¤u§@ªí³£¦³¦¹¥\¯à
¸ê®Æ§À½d¥».zip (3.42 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# sujane0701

ÁÂÁÂ sujane0701 ¤j¤j
³o­Ó¤èªkªGµM²³æ¡A
¥i¬O¤£¤Ó²Å¦X§Ú·Q­nªº.....

TOP

¦^´_ 3# Hsieh


ÁÂÁÂ Hsieh ¤j¤j
§V¤O¬ã¨s¤¤¡A
¤£¹L¤£¤Ó¯à²z¸Ñ«ç»ò¹B¥Î¡A
¥i§_Àµ½Ð Hsieh ¤j¤j»¡©ú¤@¤U¡A
·P¿E......

TOP

¦^´_ 5# dondon1495
ªþ¥ó¤w¸g¬O½d¥»ÀÉ
¸ÑÀ£ÁY¨ì
C:\Users\User\AppData\Roaming\Microsoft\Templates
¦¹¬°2010ª©¥»¦ì¸m
2003§A¥i¥Î¥t¦sÀɮפ覡
¿ï¾ÜÀÉ®×Ãþ«¬¬°"½d¥»"¡A´N¯à±o¨ì¹w³]¦ì¸m
µM«á¦A»Ý­n¥Î¦¹¥\¯àªº¬¡­¶Ã¯´¡¤J¦¹½d¥»¤u§@ªí
´N¯à¦b¥þ³¡ªº¤u§@ªí¦³¦¹¥\¯à
§Ú¤w±N¦WºÙÁôÂáA©Ò¥H¬Ý¤£¨ì³o­Ó¦WºÙ
¦ý¥u­n¦b¦WºÙ¤è¶ô¿é¤Jx
´N·|¦Û°Ê¸õ¨ì¸ÓÄ檺¸ê®Æ§À¤U¤@®æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


·PÁÂ Hsieh ¤j¤j
³o¼Ë»¡©ú¤ñ¸û®e©ö©ú¥Õ¤F   
¦A¨Ó¸Õ¸Õ¬Ý :)

TOP

¿é¤J¸ê®Æ±M¥Î
ªí³æ¥\¯à
¥i¥H¸Õ¸Õ
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD