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

[µo°Ý] ·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦X¡C

¦^´_ 9# c_c_lai

¬O«ü22´Á¨ì26´Á¤§¶¡¡A21¥X²{4¦¸¡F11¥X²{3¦¸¡F02¥X²{2¦¸¡C
¦U´Á¼Æ»P´Á¼Æ¤§¶¡ªº¬Y¸¹½X¦@¥X²{´X¦¸¡A»P¥»ÃDªºÅÞ¿è±ø¥ó©M»Ý¨DµLÃö¡C



¦Ü©ó
(¤@) «ü©w¸¹½Xªº½d³ò
     ¬O«ü "A°ò·Ç´Á¼Æ21´Á¨ì24´Á" ªº ²Ä 24 ´Á¦æ¤¤¡A¦³¥X²{ "«ü©w¸¹½X"¡H


¶ñ¤JNumber InputBox¸Ìªº¸¹½X
¬O«ü¦U²Õ¦X(§YA²Õ¦X,B²Õ¦X,A*B²Õ¦X)ªº³Ì«á¤@¦C¥²¶·¦P®É¥X²{¥ô¤@­Ó(§t)¥H¤Wªº¸¹½X¡C
EX:6#ªºSheet1!¦C22
A²Õ¦X©MB²Õ¦X©MA²Õ¦X*B²Õ¦Xªº³Ì«á¤@¦C³£¦³¦P®É¥X²{03,11,21,49ªº4­Ó«ü©w¸¹½X¡C

(¤G) A°ò·Ç´Á¼Æ*B°ò·Ç´Á¼Æ¤ñ¹ïªº´Á¼Æ
     ¦³21*18,21*19,21*20¡F
     22*18,22*19,22*20,22*21¡F23*18,23*19,23*20,23*21,23*22¡F
     24*18,24*19,24*20,24*21,24*22,24*23
     ¤£¤Ó©ú¥Õ¡A21*18 ¡A . . . . .  µ¥µ¥¬O¦ó¸q¡H


21*18 ´N¬O¥H²Ä21´Á¬°A°ò·Ç´Á¼Æ¡A¥t¥H²Ä18´Á¬°B°ò·Ç´Á¼Æ
EX:6#´N¬O¥H²Ä20´Á¬°A°ò·Ç´Á¼Æ¡A¥t¥H²Ä15´Á¬°B°ò·Ç´Á¼Æ¡F«hA°ò·Ç´Á¼Æ*B°ò·Ç´Á¼Æ=20*15
¦]¬°ÀɮצWºÙ¤£¯à¥H²Å¸¹"*"ªí¥Ü¡A¥u¦n¥H"+"´À¥N¡C

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-9 12:54 ½s¿è

EX:6#´N¬O¥H²Ä20´Á¬°A°ò·Ç´Á¼Æ¡A¥t¥H²Ä15´Á¬°B°ò·Ç´Á¼Æ¡F«hA°ò·Ç´Á¼Æ*B°ò·Ç´Á¼Æ=20*15
¦]¬°ÀɮצWºÙ¤£¯à¥H²Å¸¹"*"ªí¥Ü¡A¥u¦n¥H"+"´À¥N¡C
­×¥¿µ§»~~~~
EX:6#´N¬O¥H²Ä24´Á¬°A°ò·Ç´Á¼Æ¡A¥t¥H²Ä20´Á¬°B°ò·Ç´Á¼Æ¡F«hA°ò·Ç´Á¼Æ*B°ò·Ç´Á¼Æ=24*20
¦]¬°ÀɮצWºÙ¤£¯à¥H²Å¸¹"*"ªí¥Ü¡A¥u¦n¥H"+"´À¥N¡C

TOP

¦^´_ 12# ziv976688
  1.     Nrange = "28"
  2.     RrngA = "22-26"
  3.     CrngA = "1-2"   

  4.     RrngB = "20-24"
  5.     CrngB = "1-2"   
  6.     Number = "3,11,21-26,43,49"
½Æ»s¥N½X
³o¼Ëªºµ{¦¡½X»P¹Ï¥Üªº»¡©ú¹ïºÙ¶Ü¡H
¯à§_´N¥H¦¹¹Ï¥Ü¡A ¦A±N¥¦¸àÄÀ¤@¤U (A²Õ¦X¡BB²Õ¦X¡B°ò·Ç¦Cªº­q©w)¡H

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-9 16:43 ½s¿è

¦^´_ 13# c_c_lai
¤£¦n·N«ä¡C±z¥i¯à»~¸Ñ¹Ï¥Üªº°t¸m»P»¡©ú¤F¡F
­«·s»¡©ú¦p¤U:  

    StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21-24"
    CrngA = "1-2"
    RrngB = "18-21"
    CrngB = "1-2"
    Order = ""
    Number = "3,11,21-26,43,49"
    Ncount = "2-3"

¯à§_´N¥H¦¹¹Ï¥Ü¡A ¦A±N¥¦¸àÄÀ¤@¤U (A²Õ¦X¡BB²Õ¦X¡B°ò·Ç¦Cªº­q©w)¡H
EX¡J
·í¨úRrngA=¨ä¤¤ªº²Ä24´Á¡FCrngA=¨ä¤¤ªº1¡FRrngB=¨ä¤¤ªº²Ä20´Á¡FCrngB=¨ä¤¤ªº1®É¡F
«h¨ä
²Ä24´Á¤§²Ä3¦ì(DÄæ)¶}21(=RrngA_CrngA=A°ò·Ç²Õ¦X)¡F©¹¤U4´Á=¶}¼ú´Á¡C
²Ä20´Á¤§²Ä5¦ì(FÄæ)¶}30(=RrngB_CrngB=B°ò·Ç²Õ¦X)¡F©¹¤U8´Á=¶}¼ú´Á¡C
²Ä24´Á¤§²Ä3¦ì(DÄæ)¶}21)¥B¨ä©¹¤W4´Áªº²Ä20´Á¤§²Ä5¦ì(FÄæ)¶}30(=RrngA_CrngA +RrngB_CrngB=A°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X)¡F©¹¤U4´Á=¶}¼ú´Á¡C

·í¥Ñ²Ä24´Á(A°ò·Ç²Õ¦X)©¹¤W·j´M¡J
²Ä1¦¸¥X²{²Ä3¦ì(DÄæ)¶}21ªº´Á¼Æ¬°22´Á(²Ä1­ÓA²Õ¦XÅçÃÒª©)¡F©¹¤U4´Á=26´Á¡A¶}03,11,42,45,46,49,21
²Ä2¦¸¥X²{²Ä3¦ì(DÄæ)¶}21ªº´Á¼Æ¬°20´Á(²Ä2­ÓA²Õ¦XÅçÃÒª©)¡F©¹¤U4´Á=24´Á¡A¶}11,17,21,26,43,49,03
½Ð¨£¹Ï¥Ü1

·í¥Ñ²Ä20´Á(B°ò·Ç²Õ¦X)©¹¤W·j´M¡J
²Ä1¦¸¥X²{²Ä5¦ì(FÄæ)¶}30ªº´Á¼Æ¬°18´Á(²Ä1­ÓB²Õ¦XÅçÃÒª©)¡F©¹¤U8´Á=26´Á¡A¶}03,11,42,45,46,49,21
²Ä2¦¸¥X²{²Ä5¦ì(FÄæ)¶}30ªº´Á¼Æ¬°16´Á(²Ä2­ÓB²Õ¦XÅçÃÒª©)¡F©¹¤U8´Á=24´Á¡A¶}03,11,42,45,46,49,21
½Ð¨£¹Ï¥Ü2

·í¥Ñ²Ä24´Á(A°ò·Ç²Õ¦X)©¹¤W·j´M¡J
²Ä1¦¸¥X²{²Ä3¦ì(DÄæ)¶}21¥B¨ä©¹¤W4´Áªº²Ä5¦ì(FÄæ)¶}30ªº´Á¼Æ¬°22,18(²Ä1­ÓA²Õ¦X*B²Õ¦XÅçÃÒª©)¡F©¹¤U4´Á=26´Á¡A¶}03,11,42,45,46,49,21
²Ä2¦¸¥X²{²Ä3¦ì(DÄæ)¶}21¥B¨ä©¹¤W4´Áªº²Ä5¦ì(FÄæ)¶}30ªº´Á¼Æ¬°20,16(²Ä2­ÓA²Õ¦X*B²Õ¦XÅçÃÒª©)¡F©¹¤U4´Á=24´Á¡A¶}11,17,21,26,43,49,03
½Ð¨£¹Ï¥Ü3

¨Ì¾ÚÅÞ¿è±ø¥ó¡J·í¦U²Õ¦Xªº²Ä1­Ó¨ì²Än­Ó¤§¦UÅçÃÒª©³£¦³¥X²{¥ô1­Ó(§t)¥H¤Wªº¬Û¦P«ü©w¸¹½X«h¦¨¥ß~~
¦]¬°¥»¨Ò¡J¦U²Õ¦Xªº²Ä1­Ó©M²Ä2­Ó¤§¦UÅçÃÒª©³£¦³¥X²{03,11,21,49¡A©Ò¥H²Å¦Xn=2ªºÅÞ¿è±ø¥ó¡J¥»¨Ò¦¨¥ß¡C
½Ð¨£¶}¼úª©&3­Ó²Õ¦XªºÅçÃÒª©©Ô¥­¹Ï»¡


®ÄªGÀɮתº»Ý¨D¡J½Ð¸Ô¨£Sheet1

P.S.
A°ò·Ç²Õ¦X©MB°ò·Ç²Õ¦X©MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦Xªº¦UÅçÃÒª©¤£¬O¤@©w­n¦P¬°¤@­Ó²Õ¦X~~~
¥»¨ÒA°ò·Ç²Õ¦X©MB°ò·Ç²Õ¦X©MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦Xªº¦UÅçÃÒª©¦P¬°¤@­Ó²Õ¦X~~¯ÂÄÝ¥©¦X¡C

½Ð­«·sÀ˵ø¤ñ¹ï¨ä¥L½d¨Ò¡F¦p¦³¤£¸Ñªº¦a¤è¡A©|½Ð¤£§[§iª¾¡CÁÂÁÂ!

TOP

¦^´_ 10# ziv976688




¥H¤W 1 ~ 8 ªº
        StrRng =
        Nrange =
        num    =
        RrngA  =
        CrngA  =
        RrngB  =
        CrngB  =
        RrngC  =
        CrngC  =
        Order  =
        Number =
        Ncount =
¯à§_¤@¤@§iª¾¡H

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-10 15:42 ½s¿è

¦^´_ 15# c_c_lai
1
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "24"
    CrngA = "1"
    RrngB = ""
    CrngB = ""
    Order = ""
    Number = "3,11,21,49"
    Ncount = "2"

2
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21"
    CrngA = "2"
    RrngB = ""
    CrngB = ""
    Order = ""
    Number = "11,26,43"
    Ncount = "2"

3
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = ""
    CrngA = ""
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "3,11,21,49"
    Ncount = "2-3"

4
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "24"
    CrngA = "2"
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "11,26,43"
    Ncount = "2"

5
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21"
    CrngA = "2"
    RrngB = ""
    CrngB = ""
    Order = ""
    Number = "11,26,43"
    Ncount = "3"

6
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = ""
    CrngA = ""
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "11"
    Ncount = "3"

7
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21"
    CrngA = "2"
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "11,26"
    Ncount = "3"

8
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "23"
    CrngA = "1"
    RrngB = ""
    CrngB = ""
    Order = ""
    Number = "11,26,43"
    Ncount = "2"

¥H¤W1-8³£¥]§t¦b~~
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21-24"
    CrngA = "1-2"
    RrngB = "18-21"
    CrngB = "1-2"
    Order = ""
    Number = "3,11,21-26,43,49"
    Ncount = "2-3"

TOP

¦^´_ 16# ziv976688
ÁÂÁ§Aªº»¡©ú¡A¦ý¬O 5¡A6¡A7 ¤T­Ó¹Ï¥Ü¤¤
³£§t¦³ ²Ä 2 ²Õ¡B¥H¤Î ²Ä 3 ²Õ ©O¡I

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-10 17:28 ½s¿è

¦^´_ 17# c_c_lai
5,6,7³£§t¦³ ²Ä 2 ²Õ¡B¥H¤Î ²Ä 3 ²Õ~~©Ò¥H¬O²Ä2²Õ(Ncount=2)¤ñ¹ï¤@¦¸¡F²Ä3²Õ(Ncount=3)¥t¥~¦A¤ñ¹ï¤@¦¸^^"

©ÎªÌ§ï¦¨³o¼Ë±z¤ñ¸û²M·¡~~
5
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21"
    CrngA = "2"
    RrngB = ""
    CrngB = ""
    Order = ""
    Number = "11,26,43"
    Ncount = "2-3"

6
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = ""
    CrngA = ""
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "11"
    Ncount = "2-3"

7
StrRng = "1"
    Nrange = "28"
    num = "15"
    RrngA = "21"
    CrngA = "2"
    RrngB = "18"
    CrngB = "1"
    Order = ""
    Number = "11,26"
    Ncount = "2-3"

TOP

¦^´_ 18# ziv976688
Á|­Ó¹Ï¨Ò

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-10 21:52 ½s¿è

¦^´_ 19# c_c_lai
    StrRng = "1" ' InputBox("½Ð¿é¤JDATA!¦U·j´M¤ñ¹ïªº°_©l´Á¼Æ", "¿é¤J´Á¼Æ")
    Nrange = "28" ' InputBox("½Ð¿é¤JDATA!¦U·j´M¤ñ¹ïªº¨´¤î(¶}¼ú)´Á¼Æ", "¿é¤J´Á¼Æ")
    num = "15" 'InputBox("½Ð¿é¤J®ÄªGÀÉA¡JH½Æ»s½d³òªº´Á¶Z¼Æ", "¿é¤J¶Z´Á¼Æ")
    RrngA = "21-24" 'InputBox("½Ð¿é¤J¦U"²Ä¤@­Ó"¤ñ¹ïªº"°ò·Ç´Á¼ÆA", "¿é¤J²Ä¤@­Ó´Á¼Æ")
    CrngA = "1-2" 'InputBox("½Ð¿é¤J¦U"²Ä¤@­Ó"¤ñ¹ïªº7Äæ¨ú¥ô1~6¤§Äæ¦ì¼Æ", "¿é¤JÄæ¦ì¼Æ(1~6)")
    RrngB = "18-21" 'InputBox("½Ð¿é¤J¦U"²Ä¤G­Ó"¤ñ¹ïªº"°ò·Ç´Á¼ÆB", "¿é¤J²Ä¤G­Ó´Á¼Æ")
    CrngB = "1-2" 'InputBox("½Ð¿é¤J¦U"²Ä¤G­Ó"¤ñ¹ïªº7Äæ¨ú¥ô1~6¤§Äæ¦ì¼Æ", "¿é¤JÄæ¦ì¼Æ(1~6))
    Order = "" 'InputBox("½Ð¿é¤J¦A¿z¿ïÅÞ¿è±ø¥óªº°_¨´§Ç¸¹", "¿é¤J§Ç¸¹(1~99)©Î¤£¼W¥[(«öEnter)")
    Number = "3,11,21-26,43,49" 'InputBox("½Ð¿é¤J¦U«ü©wªº¸¹½X", "¿é¤J¸¹½X(1~49)")
    Ncount = "2-3" ' InputBox("½Ð¿é¤JÅçÃÒª©ªº³sÄò¦¸¼Æ", "¿é¤J¦¸¼Æ(2~10)")
ºñ¦r¬°¦UInputBox¤º¡A¥i¶ñ¤Jªº¼Æ¦r½d³ò©M¨ä¶ñ¤Jªº¼Æ¦r©Ò¥Nªí·N¸q~½Ð°Ñ¦Ò¡C

NUM=15~~¨ä§@¥Î¦p¤U:
±NDATA!ªº(Nrange-NUM)¨ìNrangeªºA¡JH¶}¼úª©´Á¼Æ½Æ»s¶K¤WSheet1!A7

²Ä21´Á= RrngA    ¡F01,02= CrngA=2(Äæ)
²Ä18´Á= RrngB    ¡F30= CrngB=1(Äæ)
©Ò¥H~A°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X=·í´Á(21´Á)²Ä¤@¦ì(BÄæ)¥X01,²Ä¤G¦ì(CÄæ)¥X02¡F¨ä¤W3´Á(18´Á)²Ä¤­¦ì(FÄæ)¥X30=21-12*18-5=21-12+18-5(ÀɮצWºÙ¤£¯à¥]§t*¦r¤¸¡A¥H+¥N´À)
P.S.RrngA¨ìNrange=21´Á¨ì28´Á=Nrange-RrngA=7

·í´Á(17´Á)²Ä¤@¦ì(BÄæ)¥X01,²Ä¤G¦ì(CÄæ)¥X02¡F¨ä¤W3´Á(14´Á)²Ä¤­¦ì(FÄæ)¥X30=A*B°ò·Ç²Õ¦X²Ä1­ÓÅçÃÒª©=17-12+14-5
P.S.17+7=24´Á¡F¦³¶}11,26

·í´Á(14´Á)²Ä¤@¦ì(BÄæ)¥X01,²Ä¤G¦ì(CÄæ)¥X02¡F¨ä¤W3´Á(11´Á)²Ä¤­¦ì(FÄæ)¥X30=A*B°ò·Ç²Õ¦X²Ä2­ÓÅçÃÒª©=14-12+11-5
P.S.14+7=21´Á¡F¦³¶}11,26

·í´Á(5´Á)²Ä¤@¦ì(BÄæ)¥X01,²Ä¤G¦ì(CÄæ)¥X02¡F¨ä¤W3´Á(2´Á)²Ä¤­¦ì(FÄæ)¥X30=A*B°ò·Ç²Õ¦X²Ä3­ÓÅçÃÒª©=5-12+2-5
P.S.5+7=12´Á¡F¦³¶}11,26

¦]¦¹ :A°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X¦¨¥ß¡C

19#¬O"¹Ï¥Ü3"
½Ð¤ñ¹ï"¶}¼úª©&3­Ó ²Õ¦XªºÅçÃÒª©©Ô¥­¹Ï»¡"
A¡JH & BE¡JCB  ´N«Ü²M·¡¤F

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD