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

[µo°Ý] ·Q½Ð±Ð¦³Ãö²Ö­p¬Û¥[¤Î¬Û´îªº¨ç¼Æ°ÝÃD

[µo°Ý] ·Q½Ð±Ð¦³Ãö²Ö­p¬Û¥[¤Î¬Û´îªº¨ç¼Æ°ÝÃD

°ÝÃD.jpg
2017-2-13 13:26
½Ð°ª¤âÀ°¦£¸Ñ
¥t¥~¦]¬°¤¤¤È¹L«á¤~¥i¦¹ª©­±µo©«~©Ò¥H¦b§Oªºª©­±¦³­«½Æµo©«­Y¦³¹H³W~½Ðª©¥D§R°£~·PÁÂ

D3­n=C3-D3 ´`ÁÙ°Ñ·Ó.·Ð½T»{»Ý¨D¥¿½T§_???
ù

TOP

°ÝÃD.jpg
2017-2-13 15:28
©êºp~¥i¯à§Úªí¹F±o¤£°÷¦n~
¨ä¹ê®w¦s³¡¥÷¬O§Ú¥ÎVLOOKUP±a¹L¨Óªº~¦ý¬O«o¦]¬°«~¦Wªº¬Û¦P±a¥X¤F¦P¼Ëªº®w¦s¼Æ
³o¼Ë§Ú¥Î®w¦s¥h´î¥X³f´N·|¥X²{°ÝÃD~
©Ò¥H§Ú·Q½Ð°Ý¦³¨S¦³¤½¦¡¥i¥H­×¥¿¦¨¦pªG¬O¦P¼Ë«~¦W~¥i¥H±N®w¦sJ4ªº®w¦s¶qÅܦ¨J2-I2«áªº¼Æ¶q¦p¥k¹Ï~J7ªº³¡¤À«hÅܦ¨J4¦©§¹«áªº®w¦s
~¤£ª¾¹D³o¼Ëªí¹Fªº¬O§_²M·¡~¦]¬°§Ú¤£¤ÓÀ´´`Àô°Ñ·Óªº·N«ä~·PÁ±zªº¦^À³

TOP

·Q½Ð±Ð¦U¦ì«e½ú~¹ï©ó¤p§ÌªººÃ°Ý~¤£ª¾¹D¬O¤p§Ì¸ÑÄÀ¤£²MÁÙ¬O¨S¦³½T¹êªºÀɮצU¦ì«e½úÃø¥H¸ÑµªÁÙ¬O»¡¦¹Ãþ°ÝÃD»Ý­n¥Î¨ìVBA¤è¥i¸Ñ¨M~½Ð¦U¦ì«e½ú¦h¦h«ü±Ð~ÁÂÁÂ:lovess:

TOP

¦^´_ 4# ¤p¸ô¦èªk

1. ¨S¦³Àɮפj®aÃiªº³B²z
2. ¤£¥Î¤Ó¦h´y­z¡A¦³®É¬Ý¤£À´¡A±N¼Ð·Çµª®×¶ñ¤J¤Ï¦Ó®e©ö¤F¸Ñ

³Ñ¾l = ®w¦s + ¶i³f - ¥X³f ¡AÀ³¸Ó¬O²³æªº¥[´î
¥i¥H¥Î SUMIF ¨Ó¨úÀx¦s®æ¤§«e½d³ò¤ºªº©Ò¦³ ¶i³f¤Î¥X³f ´N¯à¸Ñ¤F¡A
©Î¥Î MATCH¡BLOOKUP §ä³Ì«á¤@­Ó


¤W¯Z¤¤¥^¦£¦^ÂСA±ß¤W¦³ªÅ¦A½Í¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

D4=LOOKUP(A4,A$2:A3,D$2:D3)-LOOKUP(A4,A$2:A3,C$2:C3)
D4½Æ»s¨ìD7

TOP

ÁÂÁª©¥Dªº«ü¾É~¤p§Ì¤U¦¸µo°Ý®É·|ª`·N³o¨Ç²Ó¸`
¤]ÁÂÁÂh¤jªº¸Ñ¤j~¥¿¬O¤p§Ì©Ò»Ý¨Dªº~¥t¥~·Q½Ð±Ð¦pªG¤p§Ì·Q­n±qd2´N¶}©l°õ¦æªº¸Ü¸Ó«ç»ò­×¥¿??
ÁÂÁ¦U¦ìÀ°¦£¸Ñµª~§Ú·|§V¤O²z¸Ñ¦U¦ì¤j¤jªº«ü¾É©M¾Ç²ß{:3_59:}

TOP

¦^´_ 7# ¤p¸ô¦èªk

http://blog.xuite.net/hcm19522/twblog/486583300

TOP

¥ýÁÂÁÂH¤jÀ°¦£´£¨Ñªº¸ê®Æ~³¡¹L¥Ñ©ó¨C¤Ñ¸ê®Æ¤£¦P»Pµ§¼Æ¹L¦h¤£ª¾¬O§_ÁÙ¦³§OºØ¤è¦¡¥i¥H¸Ñ¨M¦b¦¹ªþ¤WÀÉ®×~§Æ±æª©¤j¤Î¦U¦ì«e½ú¦Aµ¹¤p§Ì¤@ÂI«Øij ´ú¸ÕÀÉ.rar (17.59 KB)
´ú¸Õ2.jpg
2017-2-16 09:21

TOP

¦^´_ 9# ¤p¸ô¦èªk

¨Ì·Ó8¼Óªº¤èªk¡A¸ê®Æ«e­±¥ý©ñ¸m ¦U«~¶µ°ò¥»®w¦s¡AÀ³¸Ó¬O¥i¥H³B²z
©p¥ý·Ó¨ä¤èªk¥ý°µ¬Ý¬Ý¡A¦A±N¦³°ÝÃDÀÉ®×PO¤W¨Ó¤~ª¾¹D§Aªº°ÝÃD¬Æ»ò?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD