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

[µo°Ý] ²Ö­p¥[Á`¹F¤@©w­È­«·s­pºâ

[µo°Ý] ²Ö­p¥[Á`¹F¤@©w­È­«·s­pºâ

½Ð°Ý¦U¦ì¡A§Ú¸ÕµÛ­n¨Ï¥Î¨ç¼Æ°µ¥[Á`¡A·í¹F¨ì¤@©w²Ö­p­È«h­«·s­pºâ¡C³]©w±ø¥ó¦p¤U¡C
¸Õ¤F«Ü¤[¤´µLªk¶¶§Q¼g¥X¨Ó¡A©Ò¥H¤W¨Ó½Ð¦U¦ìÀ°¦£¡CÁÂÁ¦U¦ì!

1. ¦P¦WºÙ(AÄæ)¡A¤£¦P¤é´Á(BÄæ)¡A¥[Á`¼Æ¶q(CÄæ)¡A·í¥[Á`CÄæ¼Æ¶q¹F0.6®É¡A½c¼Æ(DÄæ)¬°1¡C¤U¤@¦C«h¦A­«·s²Ö­p¥[Á`¡C
2. ¦WºÙ(AÄæ)­YÄÝ©ó³Ì«á¤@µ§¡A«hµL½×²Ö­p¥[Á`ªº¼Æ¶q¬O§_¹F0.6¡A½c¼Æ¬Ò¬°1
3. ¦pªG²Ö­p¼Æ¶q¬O0.6ªº­¿¼Æ®É¡A§e²{²{­¿¼Æ (¨Ò¦p¡G²Ö­p¥[Á`1.2«h¬°2)

²Ö­p¥[Á`¹F«ü©w­È­«·s­pºâ.png
2019-11-3 15:57


°ÝÃD-²Ö¥[²Î­p½c¼Æ.zip (9.9 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-11-4 09:53 ½s¿è

=IF(A2=A3,INT(SUMIF(A$2:A2,A2,C$2:C2)/0.6)-SUMIF(A$1:A1,A2,D$1:D1),1)

https://blog.xuite.net/hcm19522/twblog/588550805
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


ÁÂÁÂHcm ¤j¤jªº¸Ñµª¡C¦b³o¸Ì¦³°Ñ¦Ò¤£¤Ö±z´À¤j®a¸ÑÃDªº¨ç¼Æ¡AÅý§Ú¨ü¯q«Ü¦h¡C
¤£¹L³o­Ó¥DÃD§Ú¥i¯à¨S¦³ªí¹F²M·¡¡C §Ú¦A­«·s¾ã²z¤@¤U¦p¤U¹Ï¡C
¦]¬°§Ú·Q­nDÄæ¦ì½c¼Æ¹F1®É¡ACÄæ´N±q¤U¤@¦C¶}©l­«·s²Ö­p¡A¦Ó¤£¬O±q³Ì¤W¦CC2¶}©l²Ö­p¡C¤£ª¾¹D³o¼Ë¨ç¼Æ¬O§_¦³¿ìªk¼g¥X? ÁÙ¬O¥²¶·¨Ï¥ÎVBA¤~¯à¸Ñ?
ÁÂÁ¤j®a!

²Ö­p¥[Á`¹F«ü©w­È­«·s­pºâV2.png
2019-11-4 11:22


°ÝÃD-²Ö¥[²Î­p½c¼Æ.zip (10.9 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-11-5 12:28 ½s¿è

D2=IF(A2=A3,INT((SUM(C$2:C2)-SUM(OFFSET(C$1,,,LOOKUP(1,0/(D$1:D1>0),ROW($1:1)))))/0.6),1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# hcm19522


ÁÂÁÂÀ°¦£¡A­Y¨S¦³§A«ü¾É¡A§Ú¥i¯à·Q¯}ÀY¤]·Q¤£¥X¨Ó¥Î³o¼Ë¨ç¼Æ²Õ¦X¤è¦¡ºâ¥X¨Ó¡C¯u±o¦n¼F®`!!!
¦A¦¸·PÁÂ!:)

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD