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

[µo°Ý] ¸ê®Æ­nÀH¤é´Á¡B¶g§O¤£¦P¦Ó¦Û°Ê§ì¨ú

[µo°Ý] ¸ê®Æ­nÀH¤é´Á¡B¶g§O¤£¦P¦Ó¦Û°Ê§ì¨ú

¦U¦ì«e½ú

¦³¤@ÀɮסA¸ê®Æ­nÀH¤é´Á¡B¶g§O¤£¦P¦Ó¦Û°Ê§ì¨ú ( ¶À¦â³¡¥÷ )
¦ý¬O§Ú¤£ª¾¹D­n¨Ï¥Î­þºØ¤½¦¡¤~¥i¥H¦Û°Ê±N¸ê®Æ¶ñ¤J

¦³½Ð¦U¦ì«e½úÀ°¦£

´ú¸Õ.rar (74.73 KB)

¦^´_ 1# winint1


§â¨Ó·½¸ê®Æ·s¼W¤ë¥÷¸ò¶g§OÄæ¦ì
µM«á¥Î¼Ï¯Ã¥h­pºâ§A©Ò»Ý­nªºµ²ªG
³]©wÀx¦s®æ³sµ²¼Ï¯Ã¿ï¶µ("B2"¦ì¸m³sµ²¼Ï¯Ã¤ë¥÷)
´N¥i¥Hª½±µ¨ú±o¼Ï¯ÃÀ°§A­pºâªºµ²ªG¤F
´ú¸Õ.rar (116.76 KB)
boyao

TOP

¼Ï¯Ã¤ÀªR+1
kuoliang

TOP

boyao¤j¡AÁÂÁ±zªºµªÂÐ

¦ý¬O¥i¤£¥i¥H¨Ï¥Î¤½¦¡©O
¦]¬°³o­ÓÀÉ®×­nÅý¨ä¥L¦P¨Æ¤@°_¨Ï¥Î¡A
§Ú©È¨Ï¥Î¼Ï¯Ã¤ÀªRªº¤è¦¡¡A·|³Q¶Ã°Ê¨ì¦ÓµLªk¨Ï¥Î
( ¦P¨Æ¦³¤@¨Ç¹q¸£¤ñ¸û¤£À´¡A·|¶Ã°Ê )

¥t¥~¡A§ÚªºÅv­­©|µLªk¤U¸ü¡A¥i§_½Ð±N¤½¦¡§iª¾

TOP

·PÁ¦U¦ìÀ°¦£
¤£¹L¬O§_¥i¥H¥H¤½¦¡§e²{©O
¦A½Ð¦U¦ìÀ°À°¦£

TOP

¦^´_ 5# winint1

A3=IF(D3="","",RANK(D3,$D$3:$D$19))
C3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!D$6:D$2475))
D3=IF(C3=0,"",SUM(E3:F3)/C3)
E3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!E$6:E$2475))
F3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!F$6:F$2475))
¦V¤U½Æ»s

J3=SUMPRODUCT((LOOKUP(DATA!$A$6:$A$2475,¸ê®Æ·J¾ã!$W$2:$W$372,¸ê®Æ·J¾ã!$X$2:$X$372)=LOOKUP(2,1/($J$1:J$1<>""),$J$1:J$1))*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$I3)*(DATA!$E$6:$E$2475))
K3=SUMPRODUCT((LOOKUP(DATA!$A$6:$A$2475,¸ê®Æ·J¾ã!$W$2:$W$372,¸ê®Æ·J¾ã!$X$2:$X$372)=LOOKUP(2,1/($J$1:K$1<>""),$J$1:K$1))*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$I3)*(DATA!$F$6:$F$2475))
J3:K3¦V¥k¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh¤j
¤j·PÁ¡A§Ú©ú¤Ñ¨ì¤½¥q¸Õ¸Õ¬Ý

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD