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

[µo°Ý] ¦p¦ó¥h¹ïÀ³¥XÁ`ªí¤¤¤¬¬Û´À¥Nªº«~¸¹(ªþ¥ó)

[µo°Ý] ¦p¦ó¥h¹ïÀ³¥XÁ`ªí¤¤¤¬¬Û´À¥Nªº«~¸¹(ªþ¥ó)

·Q½Ð°Ý¤j¤j¡A
§Ú·Q¦bÁ`ªí.xlsx¤¤ªºªÅ¥ÕÄæ¦ì¡A¥i¥H±q´À¥Nªí.xlsx¤¤¡A§ä¥XÁ`ªí¤ºªº«~¸¹¡A¬O¤¬¬Û´À¥NªºÃö«Y
Á|¨Ò:Á`ªíªº²Ä¥|¦C»P²Ä¤­¦C¬d¬Ý´À¥Nªí«á¡A¥i±oª¾¬O¤¬¬°´À¥N¡AÅã¥Üªº¤è¦¡¤£¤@©w­n¼g´À¥N¡A¤]¥i¥H¥Î¼Æ¦r¥N´À
(¦ý¬O¨C¤@²Õ´À¥Nªº¼Æ¦r­n¤£¦P¡A¤~¯à°Ï¤À¡A¨Ò¦p²Ä4.5¦C´À¥N ³£¼g1¡A²Ä30.31.32¦C´À¥N «h¼g2)

¤£ª¾¹D¨ç¼Æ¦³¨S¦³¿ìªk­pºâ¥X¨Ó¡A§Æ±æ¯à°÷±q¤¤¾Ç²ß¡A¤§«á­Y¹J¨ìÃþ¦üªº°ÝÃD¥i¥H¦Û¤v¸Ñ¨M>"<

·PÁ¦U¦ì¤j¤j

file.rar (72.02 KB)

¦^´_ 1# abc9gad2016


D2 =IFERROR(MATCH(B2,[´À¥Nªí.xlsx]Sheet1!$B:$B,),IFERROR(MATCH(INDEX([´À¥Nªí.xlsx]Sheet1!$B:$B,MATCH(B2,[´À¥Nªí.xlsx]Sheet1!$C:$C,)),[´À¥Nªí.xlsx]Sheet1!$B:$B,),""))
¤U©Ô

¬Û¦P¸¹½X¬°´À¥N«~
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ª©¤j§A¦n¡A¿é¤J¤U¥hµo²{¦³¤@¨Ç¦a¤è¦³°ÝÃD ©êºp¨S»¡©ú¥Õ¡A·Q¦A°µ½Ð±Ð

¦]¬°´À¥Nªí¤¤¡ABÄæ¥i¯à¦³­«½Æ®Æ¸¹¡A¦ý¬O¹ïÀ³´À¥N®ÆCÄæ¬O¤£¦Pªº®Æ¸¹(©ÎªÌ¬Û¤Ï)
¨Ò¦p¥H¤U¡A¨ä¹ê¬O´À¥N ¥Î¤½¦¡®M¤J·|Åã¥Ü¤£¦P¼Æ¦r
DNZ132540
DNZ13250Z

¥t¥~ÁÙ¦³¤@ºØ¤ñ¸û³Â·Ðªº¨Æ¡AA´À¥NB¡BB´À¥NC  ¨ºA´N¦C¤J´À¥NC
Á|¨Ò¥H¤U:¨ä¹ê¬O¬Û¤¬´À¥Nªº
SD4231700
SD4230501
SD4023050

·P¿E¤£ºÉ

TOP

¦^´_ 3# abc9gad2016

½Ð¦bÀɮפW¼Ð¥Ü´X­Ó±¡ªp¤Î§A·Q­nªºÅã¥Ü¡A³o¼Ë¤ñ¸û®e©öÀ´¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


½Ð°Ñ¦Òªþ¥ó¡A·Q­n±o¨ì¹³Á`ªíDÄ檺µ²ªG(¦ý¼Æ¦r¤£¥Î­n·Ó¶¶§Ç¡A¥u­n°Ï¤À¥X¨C­Ó´À¥Nªº¼Æ¦r¬O¤£¦Pªº§Y¥i)
file_new.rar (72.73 KB)

TOP

½Ð°Ý¤j¤j¡A¦pªG¨ç¼Æ¯uªº¨S¿ìªk±o¨ì¥¿½Tªºµ²ªG¡AVBA¥i¥H°µ±o¥X¨Ó¶Ü

TOP

¦^´_ 6# abc9gad2016

¥Ø«e¤½¦¡¥u¯à³B²z2¶¥§¹¦¨99%¥¿½T¡A­Y­n¦h¶¥(¤]¤£ª¾·|¦³¦h¤Ö¶¥)¥i¯à¤Ó¯Ó®É¡C
±ß¤W§Ú¦A¨Ï¥Î»²§UÄæ¦ì³B²z¬Ý¬Ý¡C
¨Ï¥ÎVBAÀ³¸Ó¬O¤ñ¸û®e©ö¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-9-12 14:44 ½s¿è

¨Ì´À¥NÅÞ¿è, ¥H¤U¬O§_¬°¦@¦P¸s²Õ¡H
¸s²Õ¡]¢°¡^
SBP525320  SBP525321
SBP636650  SBP636750
SBP636750  SBP800800
SBP636750  SBP735823
SBP800800  SBP824323
SBP800800  SBP170550
SBP824323  SBP821250
SBP824323  SBP525320
SBP800800  SBP636750
SBP636650  SBP800800
SBP735823  SBP800800
SBP525320  SBP824323
SBP525321  SBP525320
¸s²Õ¦r¦ê¡G
SBP636650¡þSBP636750¡þSBP800800¡þSBP735823¡þSBP824323¡þSBP170550¡þSBP821250¡þSBP525320¡þSBP525321

¸s²Õ¡]¢±¡^
SBM511636¡þSBM532163¡þSBM312480¡þSBM511637¡þSBM51163F¡þSBM511670¡þSBM511660¡þSBM511671¡þSBM516250¡þSBM511672¡þSBM551621¡þSBM51163I¡þSBM503216¡þSBM516200¡þSBM151216

TOP

¬°¤è«K¡A±N¨âÀɨ֬°¤@ÀÉ¡G
Xl0000137.rar (51.29 KB)

µ{¦¡½X¹ï·s¤â¨Ó»¡¦³ÂI½ÆÂø¡A
¨S®É¶¡¡A´N¤£¥[µù¸Ñ¡A
´À¥NÅÞ¿è­Y¤£²Å¦X­ì·N¡A¤]¨S®É¶¡¦A­«¼g¡I

TOP

¦^´_ 9# ­ã´£³¡ªL

·PÁª©¤j¡A³o¥¿¬O¤p§Ì·Q­nªºµ²ªG!!

¤£ª¾¹Dª©¤j¼ô¤£¼ô±x§{¶¡ªºEXCEL½Òµ{¡A¦³¨S¦³±ÀÂˤW½Òªº¦Ñ®v

§Æ±æ¤]¯à±NEXCELµ¹¾Ç¦n¾Çº¡

¦A¦¸·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD