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

[µo°Ý] Excel¦p¦ó¥HÃöÁä¦r¿ï¨ú¾ã¦C¸ê®Æ¨Ã½Æ»s¨ì·s¤u§@ªí¡H

[µo°Ý] Excel¦p¦ó¥HÃöÁä¦r¿ï¨ú¾ã¦C¸ê®Æ¨Ã½Æ»s¨ì·s¤u§@ªí¡H

¦U¦ì«e½ú¦n¡A¤£¦n·N«ä¡A§Ú¥ÎExcel»s§@¤F¤@­Ó°O±bªí¬¡­¶Ã¯¡A¦p¦P¥H¤U³o­Ó³sµ²©Ò¥Ü(³sµ²¬°Google¶³ºÝµwºÐ¨Ó·½¡A½Ð¦w¤ß³sµ²)


§Ú¥H¤@­Ó¤ë¬°³æ¦ì³]¥ß¤@­Ó¤u§@ªí¡A¨C­Ó¤u§@ªí¤º¤S²Ó¤À¤é´Á¡B¤j¶µ¡B¤p¶µ¡B²Ó¸`¡B(¤ä¥X¤è¦¡)¡B(¦¬¤J¤è¦¡)µ¥µ¥¡A­YµLªk³sµ²¹Ï¤ù¡A²³æ¥H¤U¥Ü·N¹Ï¡G

ªí1
¡@¡@A¡@¡@¢Ð¡@¡@¢Ñ¡@¡@¢Ò
1¡@¤é´Á¡@¤j¶µ¡@¤p¶µ¡@²Ó¸`
2¡@5/01¡@¥ë­¹¡@¦­À\¡@¶ºÄ{
3¡@5/01¡@¥ë­¹¡@¤ÈÀ\¡@°®ÄÑ
4¡@5/02¡@¦L¨ê¡@¦W¤ù¡@¨Ê¯a¦W¤ù
5¡@5/03¡@¥ë­¹¡@¦­À\¡@¶ºÄ{

ªí2
¡@¡@A¡@¡@¢Ð¡@¡@¢Ñ¡@¡@¢Ò
1¡@¤é´Á¡@¤j¶µ¡@¤p¶µ¡@²Ó¸`
2¡@6/01¡@¥ë­¹¡@¦­À\¡@¶ºÄ{
3¡@6/02¡@¥ë­¹¡@¤ÈÀ\¡@°®ÄÑ
4¡@6/04¡@¦L¨ê¡@¤j¹Ï¡@¨Ê¯a¤j¹Ï
5¡@6/05¡@¥ë­¹¡@¦­À\¡@¶ºÄ{

§Ú§Æ±æ¯à¦b¦P¤@­Ó¬¡­¶Ã¯¸Ì·s¶}¤@­Ó¤u§@ªí(¦p¹Ï¤¤ÂÅ®Ø)¡A
·í§Ú¿é¤J¬Y¤@­ÓÃöÁä¦r¡A¨Ò¦p¡u¨Ê¯a¡v(¦p¹Ï¤¤¬õ®Ø)¡A
Excel¥i¥H¦Û°ÊÀ°§Ú¿ï¨ú©Ò¦³¤ë¥÷ªº¤u§@ªí¤ºªº¤@¾ã¦C¸ê®Æ¡A
¥]§t¤é´Á¡B¤j¶µ¡B¤p¶µ¡B²Ó¸`....(¦p¹Ï¤¤ºñ®Ø)¡A
¨Ã½Æ»s¨ì·s¤u§@ªí¤º¡A¥HÀ°§U§Ú§Ö³t²Î­p³o´X­Ó¤ë¨Ó©Ò¦³©M¡u¨Ê¯a¡v¦³Ãöªº±b¥Ø¡C

·Q¾Ç°_¨Ó¤§«á¥i¥HÀ³¥Î¦b¡A¨Ò¦p»¡¡A§Ú¤§«á·Q²Î­p³o´X­Ó¤ëªº¦­À\µæ¦â©M¤ä¥X¡A¥i¥H¤£¥Î¤@­Ó¤@­Ó¥h·j´M~
·PÁ¦U¦ì«e½ú½ç±Ð~

Excel.jpg (246 KB)

Excel.jpg

¦^´_ 1# ª÷¨©¨©

2.gif
find record1.rar (20.5 KB)
ss

TOP

¦^´_ 1# ª÷¨©¨©

Version 2
Simplified VBA code find record1v2.zip (21.11 KB)
ss

TOP

¦^´_ 2# sunnyso


    «Øij­×§ï¤@¦æ¡A¼W¥[¬d¸ß¼u©Ê¡A¥i¥H¬d 1¤ë¡B¦­À\¡B¥ë­¹ ...µ¥

    ­ì ActiveCell.FormulaR1C1 = "=ISERR(FIND(R1C2,RC[-1]))"
    §ï ActiveCell.FormulaR1C1 = "=ISERR(FIND(R1C2,PHONETIC(RC[-4]:RC[-1])))"
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089

½Ð°Ý¨Ï¥Î=PHONETIC()¦³¤°»ò­­¨î¶Ü?

¥¦¤ñ¥Î =CONCATENATE( A2 ,  ,  ,  ,  ,  ,Z2) ©M = A2,&...,..., & Z2 ²¼ä«Ü¦h
ss

TOP

¦^´_  ML089

½Ð°Ý¨Ï¥Î=PHONETIC()¦³¤°»ò­­¨î¶Ü?

¥¦¤ñ¥Î =CONCATENATE( A2 ,  ,  ,  ,  ,  ,Z2) ©M = ...
sunnyso µoªí©ó 2013-4-11 12:03



    ¶È¨ú¤å¦r®æ±µ¦X¡A¼Æ¦r®æ©¿²¤
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«z¡A¤Ó·PÁ«e½ú­Ì¤F¡A¤µ±ß´N¦^®a¨Ó¸Õ¸Õ¬Ý¡I

TOP

¦^´_ 1# ª÷¨©¨©

²K¥[«DVBAªk
find record1.rar (79.71 KB)
ss

TOP

«¢«¢¡A§Ú¤]¤£¯à¤U¸ü~~§Ú¥u¦n¨C¤Ñ¤W¨Ó»â¿n¤À¥ô°È¡A§Æ±æ¦­ÂI¤É¯Å¤U¸ü¦^¥h¥ÎÅo>U</
¤]¯¬§A¦­¦­¤É¯Å³á~¤@°_¥[ªo§aXD~~

TOP

¦ü¥G¤]¹J¨ì¸ò¼Ó¼Ó¤@¼Ëªº°ÝÃD~§V¤O¼W¥[¿n¤À¥h(²\©b)

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD