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

Ãö©ó¤é´Áªº¤ÀÃþ°ÝÃD

Ãö©ó¤é´Áªº¤ÀÃþ°ÝÃD

¥»©«³Ì«á¥Ñ mnsmrtl ©ó 2011-9-27 01:06 ½s¿è

Book1.rar (11.28 KB)
ªþÀɦp¤W
§Ú§Æ±æ¯à¹º¤À¥X¨C­Ó¤é´Á¹ïÀ³ªº¦X¬ù¤ë¥÷
Ä´¦p2009/2/22À³¸Ó¦^¶Ç3¡A¦]¬°2¤ë¥÷¦X¬ù¦b2/18¨ì´Á¤F
·PÁÂ

½Ð°Ý¤@¤U¡A¦pªG¦³¤@¥÷¸ê®Æ¡AaÄæ¬O¤é´Á¡A±q09/1/1~09/12/31
¥t¤@sheet«h¬O¦³12­Ó¤é´Á¡A¹³¬O09/1/27¡B09/3/23¡B09/6/4¡A¹ïÀ³12­Ó¼Æ¾Ú
¦p¦ó±N1/1~12/31«ö·Ó12­Ó¤é´Á¤Á³Î¡A¨Ã¦^¶Ç¹ïÀ³ªº12­Ó¼Æ¾Ú©O¡H
¤£¶i«h°h

¦p¦ó±N1/1~12/31«ö·Ó12­Ó¤é´Á¤Á³Îmnsmrtl µoªí©ó 2011-9-26 11:16


³o¬q¬Ý¤£¤ÓÀ´­C¡A­Y¥i¥H¤W¶Ç½d¨Ò¾×¡A¤ñ¸û®e©ö²z¸Ñ¡C

TOP

½d¨Ò¤w¤W¶Ç¡A½Ð¦U¦ì¥ý¶i¤£§[«ü±Ð
¤£¶i«h°h

TOP

¦^´_ 3# mnsmrtl


    F2=IF(A2<LOOKUP(TEXT(A2,"yyyym"),Sheet1!$A$2:$A$35&Sheet1!$B$2:$B$35,Sheet1!$C$2:$C$35),MONTH(A2),MONTH(A2)+1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁª©¤j¦^ÂСA¦ý¸Ó¤½¦¡·|Åã¥Ü¥X13³o­Ó¤ë¥÷
¯à§_ª½±µ¦^¶Ç¹ïÀ³ªº¦X¬ù¤ë¥÷©O¡H
¤£¶i«h°h

TOP

=IF(A16<=LOOKUP(TEXT(A16,"yyyymm"),¨ì´Á¤é!A:A,¨ì´Á¤é!B:B),LOOKUP(TEXT(A16,"yyyymm"),¨ì´Á¤é!A:A,¨ì´Á¤é!B:B),INDEX(¨ì´Á¤é!A:B,MATCH(TEXT(A16,"yyyymm"),¨ì´Á¤é!A:A,0)+1,2))

·PÁª©¤j¡A§Ú°Ñ·Ó§Aªº¥Îªk§ä¨ì¾A¦Xªº¤èªk¤F
¤£¶i«h°h

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD