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

[µo°Ý] ·s¤â½Ð°ÝÂà´«¼Æ­È°ÝÃD¡I·PÁ¡I

[µo°Ý] ·s¤â½Ð°ÝÂà´«¼Æ­È°ÝÃD¡I·PÁ¡I

¦U¦ì°ª¤â¥H¤Îª©¥D¤j®a¦n¡G
¤p§Ì³Ìªñ­n§ìªÑ²¼ªº¥N¸¹©M¦WºÙ¡A¦ý¬O¥Ø«e¹J¨ì¤@­ÓÂà´«¼Æ­Èªº°ÝÃD¡AªþÀɦ³§Úªº°ÝÃD·Ð½Ð¦U¦ì°ª¤â¥i¥HÀ°¦£¸Ñµª¡I·PÁ¡I
°ÝÃD²­z¦p¤U¡G
1.§Ú±q¨é°Ó´£¨Ñªºdde¿ï¾Ü¤FªÑ²¼¥N¸¹©MªÑ²¼¦WºÙ¡C
2.§Ú¥Î¡u¿ï¾Ü©Ê¶ñ¤W¡A­È¡v½Æ»s¤F³o¤G­Ó¿ï¶µ¨ì·sªº¤u§@ªí¡C
3.§Ú¿ï¤F¤@­ÓªÅ¥Õªº¦a¤è¥Î¤½¦¡¡uvlookup¡v¡A·Q¥Î¦¨¥u­n¥´¤J¥N¸¹¤½¦¡ªº¦a¤è·|¥X²{ªÑ²¼¦WºÙ¡C
4.°ÝÃD¬O¥X²{[n/a]¤½¦¡À³¸Ó¨S¿ù¡AÀ³¸Ó¬OªÑ²¼¥N¸¹ªº³¡¥÷¨S¿ìªk¥X²{¼Æ­È¡A¥X²{¬O¤å¦r®æ¦¡©Ò¥H¾É ­P¿ù»~µo¥Í¡C
5.¬O§_¦³«ü¥O¥i¥H¥þ³¡¤@¦¸§ï¦¨¼Æ­È©O¡H¤p§Ì¤w¸g¸Õ¤F¦n¦h¦¸ÁÙ¬O¨S¿ìªk¡C©Ò¥H­n³Â·Ð¦U¦ì¤j¤j¤F¡C·PÁ¡I
°ÝÃD.rar (3.5 KB)
tony

a.gif

TOP

·PÁÂoobird¤j¤j¡G
¦ý¬O§Ú¨S¦³¥X²{¨º­Ó¥ª¤W¨¤ªº¡uÅå¹Ä¸¹¡v©Ò¥H¤£ª¾­n«ç»ò¥s¦¹«ü¥O¥X²{©O¡H
tony

TOP

¤u¨ã~¿ï¶µ~¿ù»~Àˬd¡A©³¤U¥þ¥´¤Ä¡I

TOP

oobird¤j§A¦n¡G
·PÁ¡I§A»¡ªº¤è¦¡¡A§Ú¸Õ¤F¤w¸g¥i¥H¤F¡I¦ý¬O¤S¦³·s°ÝÃD¥X²{¡C
§Ú¥Î¥t¤@­Ó¬Ý½L¨t²Îªºdde§ì¤U¨Óªº¥N¸¹©MªÑ¦W¡A¥Î§Aªº¤G­Ó¤èªk³£¤£¦æ¡A¥i¥HÀ°¦£§Ú¬Ý¬Ý¶Ü¡H·PÁ¡I
ªþÀɦ³§Ú±qdde½Æ»sexcel¡A³Â·Ð§A¤F¡I

999.zip (1.45 KB)

tony

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2013-10-14 12:21 ½s¿è

¦^´_ 5# tonycch128

¦pªG§A§â999¨º­ÓÀɪº¼Æ¦r¤º®e¶K¨ì°O¨Æ¥»¤W¡A§A´N·|µo²{¥L«e­±¦h¥X¤F¤@­Ó²Å¸¹¡A
¾É­P¥L¦bEXCEL¸ÌÅܦ¨¤F¤@­Ó¤å¦r®æ¦¡¡A¥B¤£¥iª½±µÂà´«¬°¼Æ¦r¡A
©Ò¥H¤~·|µLªk¨Ï¥Îvlookup¡A§A¦pªG¦b1101ªº³Ì«e­±«ö¤@¤UBACKSPACE¦A«öENTER¡A
´N·|µo²{¥L¦Û°ÊÅܬ°¼Æ¦r®æ¦¡¤F¡C
¦pªG­n¤j§åÂà´«ªº¸Ü¡A¦b®ÇÃä¤@®æ¿é¤J¡G
=VALUE(RIGHT(D11,4))
´N¥i¥HÅܦ¨³æ¯Âªº¼Æ­È¤F¡AµM«á¦A¥Î¿ï¾Ü©Ê¶K¤W=>"­È"¡A³o¼Ë´N¦æ¤F¡C

TOP

½s¿è~¨ú¥N¡A§â¹«¼Ð©ñ¦b"·j´M¥Ø¼Ð"¡A«ö¦íalt¡A¿é¤J¼Æ¦r127¡A©ñ¶}¡A©³¤U"¨ú¥N¦¨"«O«ùªÅ¥Õ
«ö"¥þ³¡¨ú¥N"

TOP

¦^´_ 7# oobird


«z¾a¡A³o©Û¦n¯«§r¡I¥i¥H½Ð±Ð¨º­Óalt+127¬O¥Nªí¤°»ò¶Ü¡H

TOP

·PÁÂoobird©Mowen06¤G¦ìªºÀ°¦£¡I
¦ý¬Ooobird¤jªº¤èªk¡A§Ú¸Õ¤£¥X¨Ó¡A¤£ª¾§Ú¨BÆJ­þÃ䦳¿ù¡C
1.¦bªÅ¥Õ³B«ö½s¿è---¨ú¥N---¸õ¥X----§â¹«¼Ð©ñ¦b"·j´M¥Ø¼Ð"----«ö¦íalt¦A¿é¤J127¡A¦ý¬O§Ú«ö¦íalt¦A«ö¼Æ¦r127¬O¥X¤£¨Ó¥ô¦ó¼Æ¦r¡I§Ú¦³¾Þ§@¿ù»~¶Ü¡H
·PÁ¦^À³¡I
tony

TOP

«ö¦íalt¦A«ö¼Æ¦r127¬O¥X¤£¨Ó¥ô¦ó¼Æ¦r¡I
³o­Ó¦r¤¸¦bexcel¤¤¬O¤£Åã¥Üªº¡A«ö¥þ³¡¨ú¥N´N·|§â³o­Ó¦r¤¸®ø°£

TOP

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