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

[µo°Ý] 31ªñ¦ì­pºâ ¦p¦ó§âÀÉ®×Åܤp

[µo°Ý] 31ªñ¦ì­pºâ ¦p¦ó§âÀÉ®×Åܤp

XXXX: ¬y¤ô¸¹¡A0~9, A~Z ( I,O,U,Q,E and combination 0000 °£¥~)                                               
¥H¤U¬O§Ú­Ó¤H¨Ï¥Î³Ì²Âªº¤èªk¼g¥X
½Ð­Ó¦ì«e½ú±Ð±Ð!!ÁÂÁÂ


HP.zip (895.98 KB)
danny

¬Ý¤£¥X§Aªº°ÝÃD©Ò¦b¦a
­n°Ý¨º­Ó¤u§@ªíªº­þ­Ó¦ì¸m
§Æ±æ±ø¥ó¬°¦ó½Ð»¡©ú
¤£µMµL±q¤U¤â
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦]vba¤~­è­è±µÄ²¨ì§Ú¬O·Q½Ð±Ð¦pvba¨Ó¼g¥X¬O§_¥i¥H£z
ÁÂÁÂ!!
danny

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2010-8-8 02:52 ½s¿è

¦^´_ 3# danny001

­ì¥ý¥H¬°§A¦C¥Xªº¸ê®Æ¬O¨S¦³³W«ß©Êªº,
«á¨Óµo²{¦b¦Cªí¤¤°£¤F E I O Q U µ¥ 5 ­Ó­^¤å³Q®³±¼¥H¥~,
¨ä¥L³£¦³«ö·Ó¶¶§Ç±Æ¦C,
©Ò¥H§Q¥Î¤F¤@¨Ç¤è¦¡°µ¥X¦p   HP_a.zip (3.11 KB)   ªºÀÉ®×, (Àɮפj¤p±q 4394KB ÁY¤p¨ì 18KB)
¥D­n¬O±N°£¤F¤W­z 5 ­Ó­^¤å¦r¥H¥~ªº¤å¦r©ñ¤J¦Cªí¤¤,
µM«á·í§@¬O 31 ¶i¨îªº¼Æ¦r¨Ó­pºâ­Ó¼Æ§Y¥i.

¤ñ¸û¯S§Oªº¬OÅçÃÒªº³¡¥÷¦]­n¦Ò¼{¨ì¤å¦r¥²¶·¦b¦Cªí¤¤,ªø«×¬° 3 ½X, ÁÙ­n¤£¥]¬A "000" ³o­Ó¼Æ,
©Ò¥H¥Î¥H¤Uªº¤½¦¡¨Ó¹F¦¨ :
=AND(MATCH(LEFTB(A2,1),$E$1E$31,0)*MATCH(MIDB(A2,2,1),$E$1E$31,0)*MATCH(RIGHTB(A2,1),$E$1E$31,0)<>0,LENB(A2)=3,A2<>"000")
§Q¥Î Match() ¨ç¼Æ¨Ó½T»{¨C­Ó¤å¦r³£¦³¦b¦Cªí¤¤.

¦Ü©ó·Q§ï¦¨ VBA µ{¦¡ :
1. »P VBA µ{¦¡¦³Ãöªº°Q½×À³µoªí©ó Excelµ{¦¡°Ï
2. ¦]§AªºÀɮפ¤¨S¤°»ò¤Ó¦h»P­pºâ¦³ÃöªºªF¦è,
©Ò¥H§ï¦¨ VBA µ{¦¡¥i¯àµ{¦¡©Ò¦ûªºªÅ¶¡¤Ï¦ÓÅܧó¤j,
©Ò¥H¤£¬O«Ü«Øij§A§ï¥Î VBA.

TOP

ÁÂÁ«e½ú­Ìªº«ü¾É
½Ð°Ý¦ó®É­n¥ÎVBA¤~¤ñ¸û¾A¦X£z
danny

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD