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

[µo°Ý] excel¦p¦ó§ä¤£¦P¤u§@ªí¤¤ªº¬Y¤ë³Ì«á¤@µ§¸ê®Æ»P¤é´Á

[µo°Ý] excel¦p¦ó§ä¤£¦P¤u§@ªí¤¤ªº¬Y¤ë³Ì«á¤@µ§¸ê®Æ»P¤é´Á

¤½.JPG
2014-5-13 15:08


­ì¦³µo©«½Ð¨D°ª¤â¨ó§U¡A¦ý¤£¾å±o¬°Ô£¤£¨£¤F
¦]¦¹­«µo¤@¦¸¨D°ª¤âÀ°¦£

§Ú·Q­pºâ¬Y°òª÷¸ê®Æªº¤ë³ø¹S
¦ý¤@¨Ç°ÝÃDµLªk§JªA
1.¦p¤é´ÁÄ椤 ¸ê®Æ¬O±qE13¶}©l¡A¤@ª½¨ì¤µ¤Ñ(ÀH®É¶¡§ó·s)
2.²b­È§ó·s¸ê®Æ¬O©ñ¦b¡y¤u§@ªí1¡z¡A¦ý§Ú¼g¤½¦¡ªº¦a¤è¬O¦b¡y¤u§@ªí¤G¡z
§Ú¸ÕµÛ¼g¤U¦C¤½¦¡
INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=2)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)/INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=1)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)-1
¤]´N¬O  (2012¦~2¤ë³Ì«á¤@­Ó¤é´Áªº²b­È)/(2012¦~1¤ë³Ì«á¤@­Ó¤é´Áªº²b­È)-1  =2012¦~2¤ëªº¤ë³ø¹S

¦ý¬O¶]¥X¨Óªº­È¦³¿ù¡A¤£ª¾°ÝÃD¦b­þ

¦^´_ 1# qq619.tw


    ¥ý©w¸q
   
¹Ï¤ù 001.png
2014-5-21 13:49

    ³Ìªñ¤@¤éªº²b­È=INDEX(¸ê®Æ,MATCH(TODAY(),¤é´Á,1),3)
    (°²³]¤µ¤Ñ¬O21¤é ¦³®É­Ô¥u¦³19©ÎªÌ18ªº²b­È¡A,¥L´N·|¥h§ä¤p©ó¤µ¤éªº³Ì±µªñ¤é´Á)
    ¤W­Ó¤ëªº²b­È=INDEX(¸ê®Æ,MATCH(DATE(YEAR(TODAY()),MONTH(TODAY()),),¤é´Á,1),3)
    ¨ä¥L´N¦Û¤vµo´§
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

«á¨Ó§Ú¦A¦¸¬ã¨s¡A¥Ø«e¤w¦¨¥\¼g¥X¨Ó¤F
¤£¹LÁÙ¬OÁÂÁ¤F

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD