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

[µo°Ý] ª½¦¡§ï¾î¦¡·j´Mªº¤½¦¡

¦^´_ 10# papaya


"a" ~ "z"  ¤ñ¼Æ¦r¤j§Y¥i

TOP

¦^´_ 11# ­ã´£³¡ªL

·PÁ±zªº»¡©ú¡C
ÁA¸Ñ¤F!

¤¤¬î§Ö¼Ö^^

TOP

¦^´_ 9# ­ã´£³¡ªL
²Å¦X±ø¥óªº­È»ô»E1­ÓÀx¦s®æ
²Å¦X±ø¥óªº­È»ô»E1­ÓÀx¦s®æ.rar (2.88 KB)
­ã´£ª©¥D:
¤£¦n·N«ä¡A§Ú·Q±NSheet1!L1ªº¤½¦¡¡A¦A¶i¶¥¬°¦pSheet2ªºL1¡J±N²Å¦X±ø¥óªº­È¡A»ô»E©ñ¸m¦b1­ÓÀx¦s®æ¡A
³o¼Ë´N¤ð»Ý¦A¹w¯d³\¦h­ÓÀx¦s®æ¡C

½Ð°Ý±z¡JSheet2!L1ªº¨ç¼Æ¤½¦¡­n¦p¦ó½s¼¶¡H
ÁÂÁ±z¡I

TOP

¦^´_ 13# papaya


½c¸¹½T»{¥u¦³1~9½c??? ¥B¬°¯Â¼Æ¦r???

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-9-22 21:00 ½s¿è

¦^´_ 14# ­ã´£³¡ªL
­ã´£ª©¥D :
ÁÂÁ¦^À³¡C

1_¨C¤é¥X³f½c¼Æ¤£¤@©w¡A¦ý¥Ø«eªº¥X³f¼Æ¤£·|¶W¹L100½c¡A¤]´N¬O½c¸¹³Ì¦h¬°1~99¸¹¡C
2_½c¸¹³£¬°¯Â¼Æ­È½s¸¹¡C
3_¦P¼Æ¶qªº­«½Æ­Ó¼Æ³Ì¦h10­Ó¡C
¥H¤W ·q½Ð½ç±Ð!
ÁÂÁ±z^^

TOP

¦^´_ 15# papaya


§ÚÁ٥Ϊ©excel, µLªk¦ê±µ¤Ó¦h¤å¦r,
«Øij¥Îvba

TOP

¦^´_ 16# ­ã´£³¡ªL
­ã´£ª©¥D :
ÁÂÁ±zªº¦^À³¡C

VBA«D±`´Î¡A¦ý¬O§Ú¤£À´¡A©È¤£¦n(·|)ºûÅ@¡C
§Ú¦³¥J²Ó¬d¬Ý¤½¥q¥H©¹ªº¬ö¿ý¡A­«½Æ¼Æ¶qªº³Ì°ª¬ö¿ý¬O6­Ó¡A
¦pªG¤£¦æ¡A¬Ý¶QEXCELª©¯à®e³\¦³´X­Ó¡A´N´X­Ó¡C¨ä¥¦¤£¨¬ªº¡A§Ú¦A·Q¿ìªk¡C

­ì¦³ªºªí®æ¬O¼ÒÀÀÃD¡A©Ò¥H±N¬d¸ßªí²¾¨ìA8:B8
¦p¹Ï¥Ü :

¦A¦¸·PÁ±z^^

TOP

¦^´_ 17# papaya

¥ÎVBA¦Û­q¨ç¼Æ, »P¤½¦¡¥Îªk¬Û¦P:
²Å¦X±ø¥óªº­È»ô»E1­ÓÀx¦s®æV1.rar (7.29 KB)

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-9-23 23:50 ½s¿è

¦^´_ 18# ­ã´£³¡ªL
­ã´£ª©¥D:
¯u´Îªº¸Ñµª¡C
³o¼Ë§Ú¥u­n¤£°Êµ{¦¡½X¡A¥u­n§ï¤½¦¡¬d¸ßªº¦ì§}´N¥i¥H¤F¡C
·PÁ±z­@¤ßªº¸ÑÃD©M«ü¾É¡C

TOP

¦^´_ 18# ­ã´£³¡ªL


    ÁÂÁ½׾Â,ÁÂÁ«e½ú
«á¾ÇÂǦ¹©«¾Ç²ß«e½úªº¤è®×,¤è®×¾Ç²ß¤ß±oµù¸Ñ¦p¤U,½Ð«e½ú¦A«ü¾É

°õ¦æµ²ªG:



Function GetCTNo(xA As Range, xB As Range, xNo)
'¡ô¦Û­q¨ç¼ÆGetCTNo(),«Å§iÅܼÆ:(xA,xB)¬OÀx¦s®æÅܼÆ,xNo¬O³q¥Î«¬ÅܼÆ
'¨ç¼Æµ²ªG¬O¦r¦ê

Dim i%, TT$
'¡ô«Å§iÅܼÆ:i¬Oµu¾ã¼Æ,TT¬O¦r¦êÅܼÆ
For i = 1 To xA.Count
'¡ô³]¶¶°j°é!i±q1 ¨ìxAÅܼƼƶq(Àx¦s®æ¼Æ¶q)
    If xA(i) = xNo Then TT = TT & "," & xB(i)
    '¡ô¦pªGxA i°j°éÀx¦s®æªº­È»P xNoÅܼƬۦP!
    '´N¥OTTÅܼƱNxB i°j°éÀx¦s®æªº­È¯Ç¤J¨ì«á¤è,¥H³r¸¹¶¡¹j

Next i
GetCTNo = Mid(TT, 2)
'¡ô¥OGetCTNo¨ç¼Æ¦^¶Ç TTÅܼƱq²Ä2¦r¤¸¶}©lªº«á¤è¦r¦ê
End Function
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD