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

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

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

test05.png
2019-5-10 00:05
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°ª¤âÀ°¦£

¦^´_ 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

¦^´_ 2# rouber590324

   ¦hÁÂ.

TOP

¦^´_ 3# hcm19522


    ÁÂÁÂ.

TOP

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

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ª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

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD