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

[µo°Ý] Excel VBA±ø¥ó±Æ§Ç°ÝÃD

[µo°Ý] Excel VBA±ø¥ó±Æ§Ç°ÝÃD

·Q½Ð°Ý¦U¦ì¤j¤j
­Y¦b¦P¤@Àx¦s®æ¤º¡A¥i¥H§Q¥Î¤TºØ±ø¥ó¤U¥h±Æ§Ç¶Ü¡H
¨Ò¦p¡J
L20[9/C]N
L20[7.5/B.5]S
L20[3.5/B.5]E
L20[15.5/D]N
L20[19/F]N      
L20[15.5/F.5]N  
L20[7/C]N      
L20[2/E]S      
L20[21/E]N      
     
---------------------------------------------------------
²Ä¤@­Ó±ø¥ó¬° L20¡BL10¡BL30¡A¤¤¬A©·«e¬°¤@­Ó±ø¥ó(¬õ¦â)
±Æ§Ç§¹¦¨«á¡A¦A¨Ó¥H¤¤¬A©·¤ºªº¼Æ¦r¤j¤p±Æ§Ç(ÂŦâ)
³Ì«á¥H¤¤¬A©·¤ºªº­^¤å§@±Æ¦C(ºñ¦â)

L20[15.5/D]N

§Æ±æ·|±Æ§Ç¦¨¤U¦C±¡ªp

L20[2/E]S  
L20[3.5/B.5]E
L20[7.5/B.5]S
L20[7/C]N  
L20[9/C]N
L20[15.5/D]N
L20[15.5/F.5]N  
L20[19/F]N         
L20[21/E]N      

ÁٽЦU¦ì¤j¤jÀ°¦£·Q¤F¡AÁÂÁ¡C

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    E2:E10{=INDEX(A:A,RIGHT(SMALL(MID(A$2:A$10,2,2)*10^9+MID(A$2:A$10,5,FIND("/",A$2:A$10)-5)*10^6+CODE(MID(A$2:A$10,FIND("/",A$2:A$10)+1,1))/1%+ROW(A$2:A$10),ROW(A1)),2))

©êºp¡A¥i¥H°Ý¤@¤U
³o§PÂ_ªº¬yµ{¬O¡H ¦Ó¬õ¦r³¡¥÷¡A¬O«ç»ò§PÂ_ªº¡H

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-12-18 10:06 ½s¿è

¦^´_ 3# »a³·

µ{¦¡¤¤10^9 .10^6»P*1%¤T¼Æªº³]©w¬°²Ä¤@¤G¤£¶W¹L99 (9»P6¦¸¤è»P¤p¼ÆÂI¤@¦ì®t§O) , ²Ä¤G¤T¥Î CODEÀ³®t2¦¸§Y¥i ,³Ì«á2¦ìµ¹ROWªÅ¶¡ ,­Y¼Æ¾Ú¤j©ó99 ,ªÅ¶¡¶·¯d3¦¸¤è ,¦p¦¹©¹«e±À ,¤jªÌ*´X¦¸¤è "«í¤j" ,¦AÂ^¨úROWªÅ¶¡ªº¦ì¸m¶i¦æ±Æ§Ç
´X¦¸¤è¨S©T©w ­«ÂI¤£¥i­«Å|
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# »a³·


    »²§UÄæ+¦Û­q±Æ§Ç¤§¤è¦¡¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/38zBPM
E0137_1.png
2017-12-18 11:06

TOP

¦^´_ 4# hcm19522


   ¤µ¤Ñ¹ê»Ú¨Ï¥Î¤F¤@¤U¡Aµ²ªG¾ã±øªº±Æ§Ç³£¥u¦³L20[2/E]S....
    ¤£ª¾¹D¬O¦b­þ¤@­ÓÀô¸`¥X¿ù¤F

-----------------------------------------------------------------
­Y¦b³o­Ó±ø¥ó¥i¥H§¹¦¨¤U¡A¥i¥H¤]±N¬Û¾FªºÀx¦s®æ¾ã¦C²¾°Ê¶Ü¡H
L20[2/E]S  ³o­Ó¬O¦bBÄæ¡AÁÙ¦³A¡BCÄ檺¸ê®Æ¤]¥i¥H¤@¦P²¾°Ê¶Ü¡H

TOP

¦^´_ 6# »a³·

½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 7# hcm19522


    ¦³³á¡A§Úª¾¹DCtrl+Shift+Enter
    ¤µ¤Ñ¤ÏÂЪº¦A¸Õ¤F´X¦¸¡A³£ÁÙ¬O¤@¼Ëªº±¡ªp

    µ²ªG¥X¨Ó·|¬O E2:10 ³£¬O L20[2/E]S

TOP

¦^´_ 8# »a³·

­ì½ZE2:E10{=INDEX(A:A,RIGHT(SMALL(MID(A$2:A$10,2,2)*10^9+MID(A$2:A$10,5,FIND("/",A$2:A$10)-5)*10^6+CODE(MID(A$2:A$10,FIND("/",A$2:A$10)+1,1))/1%+ROW(A$2:A$10),ROW(A1)),2))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 9# hcm19522


   

¹êÅçµ²ªG

Â^¨ú.PNG
2017-12-20 16:12



§Ú¨ú¤U ¡eINDEX(A:A,RIGHT(SMALL(MID(A$2:A$10,2,2)*10^9+MID(A$2:A$10,5,FIND("/",A$2:A$10)-5)*10^6+CODE(MID(A$2:A$10,FIND("/",A$2:A$10)+1,1))/1%+ROW(A$2:A$10),ROW(A1)),2))¡f
¨Ó¨Ï¥Î¡Aµ²ªG±o¨ìªº¬O ¹Ï¤ùªºµ²ªG...

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD