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

[µo°Ý] ½Ð±Ð¤@­ÓÄƸ¹(~)ªº°ÝÃD(¤w¸Ñ¨M)

[µo°Ý] ½Ð±Ð¤@­ÓÄƸ¹(~)ªº°ÝÃD(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ bruse ©ó 2012-3-6 09:07 ½s¿è

¦b¨Ï¥Îexcelªºvlookup¤½¦¡®É¡A­Y¤ñ¹ïªº¸ê®Æ¤¤§¨¦³ÄƸ¹(~)¡Avlookup´N·|§ä¤£¨ì¡A½Ð°Ý¤½¦¡­n¦p¦ó­×¤~¦³¸Ñ¡H
­ì¥»·Q¥Î¡u¨ú¥N¡vªº¥\¯à±NÄƸ¹(~)¸m´«±¼¡A¦ý¬O³s¡u¨ú¥N¡v¤]§ä¤£¨ìÄƸ¹(~)¡C·Q½Ð°Ý¦U¦ì¥ý¶i¦³¨S¦³¸Ñ¨Mªº¤è¦¡¡AÁÂÁ¡I

¦^´_ 1# bruse


    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

·PÁÂHsieh¤j¤j¡A­è­è¸Õ¹L¬O¥i¦æªº¡C
¤£¹L¦]¬°¦³ÄƸ¹(~)ªº¸ê®Æ¬O°ò¥»¸ê®Æ¡A§Æ±æ¯à¶È¥i¯àªº§e²{­ì¥»¸ê®Æªºªø¹³¡A·Q½Ð±Ðvlookup§ä¤£¨ìªº°ÝÃD­n¦p¦ó¸Ñ©O¡H
­è­è¹Á¸Õ¥Îreplace¸m´«¡A¤£¹L¦ü¥G¨S§Ú·Q¹³¤¤ªºÂ²³æ¡CÁÂÁÂÅo¡I

TOP

~~
~*
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 4# gong
gong§A¦n
ÁÂÁ§Aªº¦^ÂÐ
~*¬O§ä´M*ªº¥Îªk¡A½Ð±Ð¦pªG­n§äªº¬OÄƸ¹(~)¥»¨­¡Avlookup©Î¬Oreplace­n¦p¦ó¹ê§@¡H
¥i¥H¼gªº¨ãÅé¤@ÂI¶Ü¡HÁÂÁ¡I

PS:©êºpª¦¤å«Ü¤[¨S¦³¬Ý¨ì¸Ñªk¡A·j¯Á¤]¥u¯à·j¨ì¼ÐÃD¡C§Æ±æ¦³¤Hª¾¹D¥i¥H¤£§[½ç±Ð¡C·P®¦Åo¡I

TOP

¦^´_ 5# bruse


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
·PÁÂHsieh¤j¤j¤£¹½¨ä·Ðªº«ü¾É¡A¹ê»Ú¾Þ§@¬O¥i¦æªº
¤£¹L¥Ø«eªºÀ³¥Î¤Wªº»Ý¨D¦p¤U¹Ï¡G

¦³¾÷·|ÂÇ¥Ñexcel¤º«Ø¤½¦¡¨Ó¹F¦¨»Ý¨D¶Ü¡H

¤£¹LHsieh¤j¤jµ¹ªº¤èªk¤]µ¹¤F§Ú¤@­Ó·s¤è¦V¡AÁÂÁ¡I

TOP

¦^´_ 7# bruse

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh
·PÁÂHsieh¤j¤j
­è­è¸Õ¹L¬O¥i¦æªº¡A³o¯uªº¬O¤Ó¯«©_¤F
³o´X¤Ñ¤WGOOGLE³£¹M´M¤£¨ì¸Ñ¨M¤è¦¡
ªGµMÁÙ¬O­n¦h½Ð±Ð«e½ú, ÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD