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

[µo°Ý] ´M¨D±ø¥ó¤½¦¡´î¼Æ

[µo°Ý] ´M¨D±ø¥ó¤½¦¡´î¼Æ

TEST05.zip (8.13 KB)

´M¨D±ø¥ó¤½¦¡´î¼Æ

1.¥ý§PÂ_ÄæB©M,¦AÄæC¦³¬Û¦P²Å¦Xªº¸ê®Æ
2.in qty´î out qty
3·Q­nÄæHªºµ²ªG
¦]¬°¥­®É­n¼W¥[¦C¦©´î¥X³fªº¼Æ,©Ò¥H¨S¦³©T©w¤½¦¡,§Æ±æ¦³excel°ª¤âÀ°¦£

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-5-11 11:37 ½s¿è

=SUMPRODUCT(($B$2:$B$65536=B2)*($C$2:$C$65536=C2),$E$2:$E$65536)-SUMPRODUCT(($B$2:$B$65536=B2)*($C$2:$C$65536=C2),$G$2:$G$65536)
ù

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522


    ÁÂÁÂ.

TOP

¦^´_ 2# rouber590324

   ¦hÁÂ.

TOP

¦^´_ 2# rouber590324
¦pªG¨â­Ó¬Û¦PªºINQTY,µ²ªG¿ù»~.


   
INVOICE        IN DATE        IN QTY
JOHN-001        30-Apr-19        500
JOHN-001        30-Apr-19        300

BALANCE QTY
550
550

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD