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

[µo°Ý] ¦p¦ó¦b²£«~¥X³f«á¡A°¨¤W±oª¾ÁˤUªº®w¦s¶q

[µo°Ý] ¦p¦ó¦b²£«~¥X³f«á¡A°¨¤W±oª¾ÁˤUªº®w¦s¶q

½Ð°Ý¤j¤j¦p¦ó¦b²£«~¥X³f«á¡A°¨¤W±oª¾ÁˤUªº®w¦s¶q¡A¦Ó®w¦sªíªº¼Æ¶q¬OÂꦺªº¡A¤]ÁôÂñ¼ ¦p¦ó­pºâÁ˾l¼Æ.zip (6.98 KB)
julie

C2=VLOOKUP(A2,F:G,2,)-SUMIF(A$2:A2,A2,B$2:B2)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD