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

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

C2=VLOOKUP(A2,F:G,2,)-SUMIF(A$2:A2,A2,B$2:B2)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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