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

¦h¤u§@ªí¬Û³sµ²

ÁÂÁÂF¤j,´ú¸Õªí¤W¶Ç
·s¼W°ÝÃD

´ú¸Õªí.rar (14.18 KB)

TOP

¦^´_ 13# ws2315


    ¤£À´°ÝÃD¦b­þ,ÁÙ¦³¦pªG¦^ÂЪº¸Ü,À³¸ÓÂI©«¤l¤U­±ªº¦^ÂÐÁä

TOP

¦^´_ 12# fengetianxia


½ÐF¤j ¦U¦ì°ª¤â¥H¨ç¼Æ±Ð¾É,¤£¦P¤é´Á¡B®É¶¡¤§¥[Á`

¨Ò¦p¨t²Î¤é´Á¬°106¦~1¤ë1¤é(§Y¨Ì¨t²Î®É¶¡§ì¤u§@ªí¤º¬Û¦P¤é´Á)
´ú¸Õ2ÀÉB5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°0001~0756,¼Æ¶q¤§¥[Á`
´ú¸Õ2ÀÉC5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°0801~1556,¼Æ¶q¤§¥[Á`
´ú¸Õ2ÀÉD5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°1601~2356,¼Æ¶q¤§¥[Á`

106¦~1¤ë2¤é¨Ì¦¹¦P¤W

´ú¸Õªí.rar (4.47 KB)

TOP

¦^´_ 13# ws2315


    20161231 ¤£¦P¤é´Á¡B ®É¶¡¤§¥[Á`.rar (9.45 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ws2315

VBA§Ú¤£¼ô
¥i¥H¥tPO¨ìEXCEL VBA µ{¦¡°Ï¡A¨ºÃä°ª¤â¦h

¦^ÂЭn«ö©ó¤U¤è«ö "¦^ÂÐ"¡A³o¼Ë¤~¯à³qª¾§A­n°Ýªº¤H¡A¤j®a¤£¨£±o¨C¤é¤Wºô°Q½×¡A¤@¤£¤p¤ß´Nº|±¼¤F¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ML089


    ÁÂÁÂM¤j,¥´¶}´ú¸Õ2ÀÉ«ö§ó·s©Î¤£§ó·s,¥X²{#VALUE!
   OFFSET¨ç¼Æ·íÃö³¬ÀÉ®×·|¥X²{,¬O§_­nÀx¦sÀÉ®×,¥i§_¥Î¨ä¥L¨ç¼Æ¥N´À

   ´ú¸Õ2ÀÉB5 C5 D5·|¤@ª½§ì¨C¤Ñªº¼Æ¶q,¤£¥Î¦b¼W¥[B6 C6 C6
   ¨Ò¤µ¤Ñ106¦~1¤ë1¤é§ì¤µ¤Ñ,©ú¤Ñ106¦~1¤ë2¤é§ì©ú¤Ñ,3.......31¤é,¨Ì¦¹Ãþ±À
   106¦~1¤ë1¤é
   ´ú¸Õ2ÀÉB5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°0001~0756½d³ò,¼Æ¶q¤§¥[Á`
   ´ú¸Õ2ÀÉC5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°0801~1556½d³ò,¼Æ¶q¤§¥[Á`
   ´ú¸Õ2ÀÉD5§ì´ú¸Õ1ÀÉ106¦~1¤ë1¤é,®É¶¡¬°1601~2356½d³ò,¼Æ¶q¤§¥[Á`
   106¦~1¤ë2¤é
   ´ú¸Õ2ÀÉB5§ì´ú¸Õ1ÀÉ106¦~1¤ë2¤é,®É¶¡¬°0001~0756½d³ò,¼Æ¶q¤§¥[Á`
   ´ú¸Õ2ÀÉC5§ì´ú¸Õ1ÀÉ106¦~1¤ë2¤é,®É¶¡¬°0801~1556½d³ò,¼Æ¶q¤§¥[Á`
   ´ú¸Õ2ÀÉD5§ì´ú¸Õ1ÀÉ106¦~1¤ë2¤é,®É¶¡¬°1601~2356½d³ò,¼Æ¶q¤§¥[Á`

TOP

¦^´_ 16# ws2315

»Ý­n´ú¸Õ1.xlsÀɮפ@¨Ö¶}±Ò¤½¦¡¤~¯à§ìªº¨ì

­Y­n¨Ì¨C¤é¥h§ì¡A³]A5¤½¦¡©Î±N¸Ó¤½¦¡¨ú¥N­ì¤½¦¡¤¤ªºA5
A5 =TEXT(TODAY(),"e¦~m¤ëd¤é")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 17# ML089


    M¤j ¥i¤W¶ÇÀÉ®× ·PÁÂ

TOP

¦^´_ 18# ws2315


    A5 =TEXT(TODAY(),"e¦~m¤ëd¤é")
³oÀ³¸Ó¬O«Ü²³æªº³]©w
¿Ë¤â°µ°µ¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 19# ML089


   ÁÂÁÂM¤j ¥ý¸Õ¸Õ

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD