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

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó§ì¸ê®Æ¸Ì­±·í¤ë¤é´Áªº²Ä¤@¤Ñ¸ò³Ì«á¤@¤Ñ

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó§ì¸ê®Æ¸Ì­±·í¤ë¤é´Áªº²Ä¤@¤Ñ¸ò³Ì«á¤@¤Ñ

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:19 ½s¿è

½Ð°Ý§Ú¦pªG­n§ì¸ê®Æ¸Ì­±¨C¦U¤ëªº²Ä¤@¤Ñ¸ò³Ì«á¤@¤Ñ¸ê®Æ
­n¦p¦ó¼g?


ÀY§À.rar (5.64 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¦^´_ 1# freeffly


    ÀY§À.zip (9.63 KB)
1

µû¤À¤H¼Æ

    • gong: ­È±o¾Ç²ßª÷¿ú + 2
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ÁÂÁª©¥D
   °Ý¤@¤UISERROR(MATCH(TEXT($A$2:$A$48,"yyyymm")
    ¦b³o¸Ì¨Ï¥Îiserror¨ç¼Æªº§@¥Î¬O?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# freeffly


    MATCH(TEXT($A$2:$A$48,"yyyymm"),$F$1:F1,0)
·|±NAÄ檺¦~¤ë¦r¦ê¦b¤½¦¡©Ò¦bÀx¦s®æ¥H¤Wªº¦ì¸m´M§ä¬O§_¦s¦b
·í¥¼¥X²{¸Ó¦~¤ë¦r¦ê®É¡A´N·|¶Ç¦^¿ù»~­È
¤]´N¬O­n±o¨ì¤£­«½Æ¦~¤ë²M³æªº¸Ü´N¬O³o¨Ç§ä¤£¨ìªº¦r¦ê
©Ò¥H§Q¥ÎISERROR±N³o¨Ç¦ì¸m¶Ç¦^TRUE¡A­Y¤w¥X²{¦bFÄ檺¤é´Á¦r¦ê¸Ó¦ì¸m±Ï¦^¶Ç¦^FALSE
³o¨ÇÁ³¤Î­È¥h°£¥H1ªº®É­Ô¡A´N·|¶Ç¦^1»P#DIV/0!ªº°}¦C
¦A¨Ï¥ÎMATCH¥h§ä¨ì³o°}¦C¤¤²Ä¤@­Ó1¥X²{ªº¦ì¸m§@¬°INDEX¨ç¼Æªºrow_num¤Þ¼Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ÁÂÁª©¥DÁ¿¸Ñ
   ¨S¦³¨Ï¥Î¹Lªº¤è¦¡ªGµM»Ý­nªá¦hÂI®É¶¡®ø¤Æ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD