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

[µo°Ý] ¦p¦ó§â­«½Æªº¸ê®Æ¥h±¼¡H

[µo°Ý] ¦p¦ó§â­«½Æªº¸ê®Æ¥h±¼¡H

¥»©«³Ì«á¥Ñ ¤p«L«È ©ó 2011-1-17 19:25 ½s¿è

¦pªG¤@­ÓEXCEL FILE¤¤¦³¨Ç¬ö¿ý¬O­«½Æªº¡A§Úª¾¹D¥i¥H¥Î¡u¶i¶¥¿z¿ï¡vªº¤£­«½Æªº¸ê®Æ©â¥X¨Ó¡C¨Ò¦p§Úªº¸ê®Æ¦³¤T­ÓCOLUMN¡G©m¦W¡B¯Z§O¡BID¡A§Ú¥HID¨Ó¿z¨«­«½Æªº¸ê®Æ¡A§Ú«K¯à«Ø¥ß°ß¤@°O¿ýªº²M³æ¡C
¦ý¦pªG§Ú»Ý­n¦h¹L¤@­ÓCOLUMNªº¸ê®Æ¨Ó§PÂ_¬O§_­«½Æ¸ê®Æ¡A¨Ò¦p¦³A-E¤­¯Z¤H¡A¨C¯Z¦³10­Ó¤H¡A½s¸¹¥Ñ1¦Ü10¡C³æ¬Ý¤@­ÓCOLUMN¬O¨S¦³¥Î¡A¦]¬°ÄÝ©ó8¸¹ªº¦³¤­­Ó¡FÄÝ©óB¯Zªº¤]¦³10­Ó¡A§Ú»Ý­n§â¨â­ÓCOLUMNªº¸ê®Æµ²¦X¤~¯à§PÂ_¬O§_­«½Æ(§YB¯Z8¸¹)¡A½Ð°Ý³o¥i¥H¦p¦ó°µ¡HÁÂÁ¡I

°ÝÃD2¡G
¦pªG§Ú¤£»Ý­n§â¡u°ß¤@¡vªº°O¿ý©â¥X¨Ó¡A¥u»Ý­n­pºâ¬ö¿ýªº¼Æ¦r¡A¤S¥i¥H«ç¼Ë°µ¡H
¨Ò¦p¦í°|°O¿ý¤¤¥]¬A¡G¡u½s¸¹¡v¡B¡u©Ê§O¡v¡B¡uÂå°|¦W¡v¡B¡u¬O§_¤w¸g¦º¤`¡vªº¸ê®Æ¡A¦ý¦]¬°³¡¥÷¯f¤H¥i¯à¦h¦¸¤J°|«á¤~¦º¤`¡A©Ò¥H¥L­Ìªº°O¿ý¤ñ¸û¦h¡C¦pªG§Ú­n­pºâ¤£¦PÂå°|ªº¦º¤`²v©Î¦º¤`¼Æ¦r¡A§Ú¥²»Ý­n§â­«½Æªº¸ê®Æ¿z¨«¡A¤£¯à¥ÎCOUNTIFªº¤èªk§a....

§Ú¬O¥ÎEXCEL2003ªº

TOP

¥»©«³Ì«á¥Ñ linshin1999 ©ó 2011-1-17 20:48 ½s¿è

§A¦n:¥H¤U­ÉªáÄm¦ò³o¬O Hiesh ª©¥D,¦^µªª©¤Í°Ýªº°ÝÃD©Ò¦^µªªºµª®×,§A¥i¥H°Ñ¦Ò¬Ý¬Ý:

Sub Ex()
Set d = CreateObject("Scripting.Dictionary")
With Sheets(2)
For Each a In .Range(.[A1], .[A65536].End(xlUp))
   d(a.Value) = a.Offset(, 1)
Next
With Sheets(1)
For Each a In .Range(.[A1], .[A65536].End(xlUp))
   a.Offset(, 3) = d(a.Value)
Next
End With
End With
End Sub

http://forum.twbts.com/viewthread.php?from=notice&tid=2398


©ÎªÌ§A¥i¥H«e©¹¥H¤Wªººô­¶¥h°Ñ¦Ò:¹ïªì¾ÇªÌ Dictionary ­nªá¤@ÂI¤ß«ä,¦ý¬O§A­nªºµª®×´N¬O¥Î Dictionary ¨Ó¸Ñ¨M.
V98

TOP

¦^´_ 2# ¤p«L«È


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

TOP

¦^´_ 3# linshin1999


    ½Ð°Ý³o­Ó¬O¸Ñ¨M§Ú²Ä¤@­Ó°ÝÃDªº¤èªk¶Ü¡H
§Ú¹ïvbaÁÙ¤£¬O¨º»ò¼ô±x¡A¤£¤Ó©ú¥Õ¦p¦ó¨Ï¥Î¡A§Ú§â¥¦©ñ¦bvba¤¤¡Arun¤F¤]¨S¦³®ÄªG......
¤£¹LÁÙ¬OÁÂÁ§Aªº¼ö¤ßÀ°§U

TOP

¥»©«³Ì«á¥Ñ ¤p«L«È ©ó 2011-1-18 16:53 ½s¿è
¦^´_  ¤p«L«È
Hsieh µoªí©ó 2011-1-17 21:09



­ì¨Ó§Ú³Ìªì»¡ªº¤èªk¬O¥i¦æªº¡A¦ý¬O§Ú¾Þ§@¦³°ÝÃD¤~§Ë¿ù¤F¡AÁÂÁª©¤jªºÀ°§U¡C
¨º»ò§Ú²Ä¤G­Ó°ÝÃD¬O¤£¬O¤£¯àª½±µ¥Hformula©Îexcel¥\¯à­pºâ¡A­n¾ã²z¼Æ¾Ú«á¤~¯à­pºâ¡H

TOP

¦^´_ 6# ¤p«L«È

¿z¿ï«á­pºâÀ³¸Ó¤ñ¸û§Ö³t
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­ì¨Ó¶i¶¥¿z¿ï ÁÙ¥i¥H¥Î¤£¦Pªº¸ê®ÆÄæ¨Ó°µ ³o¼Ë¥i¥HÀ³¥Î¦b§Úªº­pºâ¦¨ÁZªºÀÉ®× ¥H¤Î¾Ç¥Í¸ê®Æªº°O¿ý ¤è«K¬d¸ß©Î¿z¿ïµ¥µ¥ ¥ý¸Õ¸Õ¬Ý ¤S¾Ç¤F¤@©Û

TOP

¦^´_ 7# Hsieh


    ÁÂÁ¶Wª©ªºÀ°§U¡A³o¨à¯uªº¾Ç¨ì«Ü¦h¡A±q«eÁÙ¥H¬°excel¬O­Ó²³æªº³nÅé.....
ÁÙ¦³°}¤l¾Ç©O

TOP

ÁÙ¦³¤@­ÓÃþ¦üªº°ÝÃD»Ý­n¸Ñ¨M¡A¦ý¤£·Q­J¶Ã¶}post®ö¶O½×¾Â¸ê·½¡A°ß¦³¸òpostµo°Ý§a¡I
§Ú§Ë¤F¤@­Ó¤d¦h¤Hªº¦W³æµ¹¦ÑÁó§@­×§ï¡A¥L¦Û¤v¼W´î«á¥æµ¹§Ú¡A¦ý§Ú¤£²M·¡¦³¬Æ»ò°O¿ý¬O·s¥[©Î¤w§R°£¡C§Ú²{¦b¥Îªº¤èªk¬O¨â­Óªí³£¦V¥t¤@­Óªí¥Îvlookup¡A¹J¨ì¦³#N/A«h¥Nªí¥t¤@­Óªí¨S¦³³o­ÓRECORD¡A¦ý³o­Ó¤èªk¦³ÂI²Â¡A·Q½Ð±Ð¤j®a¥i¥H¥Î¨ä¥L¤èªk¡A¨Ò¦pfilter¥i¥H¸Ñ¨M©O¡HÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD