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

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

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

E2 =IFERROR(--TEXT(IF(COUNTIF(A$2:A2,A2)=1,VLOOKUP(A2,[®w¦s´ú¸Õ.xlsx]¤u§@ªí1!$A:$B,2,FALSE),LOOKUP(1,0/(A$1:A1=A2),E$1:E1))-D2,"0;!0"),"µL¦¹®Æ¸¹")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ¤p¸ô¦èªk ©ó 2017-2-18 14:08 ½s¿è

¥X³fªí´ú¸Õ1.rar (38.26 KB) ®w¦s´ú¸Õ1.rar (36.73 KB)
·Q¦A½Ð±ÐH¤j¤@­Ó°ÝÃD~·PÁÂ

´ú¸Õ.jpg (314.05 KB)

´ú¸Õ.jpg

´ú¸Õ4.jpg (226.96 KB)

°ÝÃD

´ú¸Õ4.jpg

®w¦s´ú¸Õ.rar (36.7 KB)

¥X³fªí´ú¸Õ1.rar (39.55 KB)

¥X³fªí´ú¸Õ1.rar (39.55 KB)

®w¦s´ú¸Õ1.rar (36.73 KB)

TOP

¦^´_ 13# hcm19522


    «D±`ÁÂÁÂH¤jªºÀ°¦£~¤p§Ì¤]·|§V¤O¤F¸Ñ¨º¨Ç¤½¦¡¬O«ç»ò¼gªº~©Z¥Õ»¡²{¶¥¬q¤p§ÌÁÙ¬O¤@ª¾¥b¸Ñ~§Æ±æ¥H«á¥i¥H¸ò¤j¤j¨Ì¼Ë¦b³o­Óºô¯¸¤WÀ°§U§O¤H~ÁÂÁÂ^^

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-2-17 20:10 ½s¿è

D2=IFERROR(IF(COUNTIF(A$2:A2,A2)=1,INDEX([®w¦s´ú¸Õ.xlsx]¤u§@ªí1!$B:$B,MATCH(A2,[®w¦s´ú¸Õ.xlsx]¤u§@ªí1!$A:$A,)),LOOKUP(1,0/(A$1:A1=A2),D$1:D1)-LOOKUP(1,0/(A$1:A1=A2),C$1:C1)),"µL¦¹®Æ¸¹")

TOP

¥X³fªí´ú¸Õ.rar (8.54 KB) ®w¦s´ú¸Õ.rar (36.7 KB) ¦^´_ 10# ML089


    ¦]¬°¤p§Ì¬ã¨s¤F«Ü¤[¤£ª¾¹D«ç»ò§â8Fªº°ò¥»¥X³f¤Î®w¦s¼Æ©ñ¨ì¥X³fªí¤W,¦b¦¹ªþ¤W©Ò»Ý¨Dªº2­ÓÀÉ®×~½Ð«e½ú¦Aµ¹¤p§Ì«Øij~
©êºp¦]¬°¹ïEXCEL¤F¸Ñ¨S³o»ò²`~¦³¨Ç«e½úªº«Øij¥u¯à¤j·§¤F¸Ñ~©Ò¥H­n³Â·Ð¦U¦ì«e½ú~«D±`·PÁÂ

TOP

¦^´_ 6# hcm19522


    ·Q¦A½Ð±Ð¤@¤U~¤p§Ì¸ÕµÛ¥Î±zªº¤è¦¡°µ­×¥¿«o¥X²{«Ü©_©Çªº¼Æ¦r¤£ª¾¹D¬O­þ¸Ì°µ¿ù¤F¶Ü~§Æ±æ¤j¤j¦b«üÂI¤@¤U¤p§Ì~·PÁÂ

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

¥ýÁÂÁÂ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)

TOP

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

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

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

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD