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

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

¦^´_ 6# hcm19522


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

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

¥»©«³Ì«á¥Ñ 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

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

¥»©«³Ì«á¥Ñ ¤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

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

®w¦s´ú¸Õ1.rar (36.72 KB) ¦^´_ 16# ML089

ÁÂÁª©¤jªº¦^ÂÐ~¤p§Ì´ú¸Õ«áµo²{·íIJµo°Ý±o¤£°÷§¹¾ã~§Æ±æª©¤j¥i¥H¦bÀ°¤p§Ì¬Ý¤@¤U¤p§Ìªº°ÝÃD~¸U¤À·PÁÂ

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

TOP

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


¤£¬O¤ÓÀ´§A·Q­n¬Æ»ò
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 18# ML089


    ª©¤jÁÂÁ±z©âªÅ¦^ÂÐ~¤p§Ì¿òº|ªº»Ý¨D¬O~¦bDÄ檺³¡¤À~¥Ñ®w¦s±a¹L¨Óªº¼Æ¶q¬°0¥B¥X³f®Æ¸¹¥u¦³³æ¤@µ§ªº¸Ü~«h¥Î¹s´î±¼¥X³f¼Æ(¨Ò¦pD14)0-421=421~
­Y®w¦s¼Æ¬°¹s¥X³f®Æ¸¹­«½Æªº¸Ü«h¤£¥²²Ö­p~¨Ò¦p(D15.D16.D17)¥Ñ3µ§­«½Æ®Æ¸¹¦U¥X³f¶q¬°25,5,40~«h¬°0-25=-25   0-5=-5  0-40=-40
¦]¬°¸ò¦³®w¦s¼Æ¶qªº»Ý­n²Ö­p¬Û´î±o¤£¤@¼Ë~¤£ª¾¹D¬O§_¥i¥H°µ¨ì~ÁÂÁª©¤j

TOP

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

¦bDÄ檺³¡¤À~¥Ñ®w¦s±a¹L¨Óªº¼Æ¶q¬°0¥B¥X³f®Æ¸¹¥u¦³³æ¤@µ§ªº¸Ü~«h¥Î¹s´î±¼¥X³f¼Æ(¨Ò¦pD14)0-421=421

?
D14¥Ñ®w¦s±a¹L¨Óªº¼Æ¶q¬°231¤£¬O0¡A³o¨Ò¤lÅý¤H§x´b¡C

§A­nÁ¿©Ò¦³§ì¸ê®ÆªºÅÞ¿è¥þ³¡»¡©ú¡AªF¥[¤@ÂI¦è¥[¤@ÂI¤w¸g¶Ã±¼¤F¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD