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

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

¦^´_ 20# ziv976688
½Ð°Ý¡G
A.  RrngA = "21-24" «üªº¬O ²Ä21´Á¨ì²Ä24´Á´Á¼Æ¡A¦¹¶µ¤wµL±e¸mºÃ¡C
    CrngA = "1-2"
       (½Ð¿é¤J¦U"²Ä¤@­Ó"¤ñ¹ïªº7Äæ¨ú¥ô1~6¤§Äæ¦ì¼Æ", "¿é¤JÄæ¦ì¼Æ(1~6)")
    ¥Ø«e¤§¿é¤J­È¬° "1-2"¡A ¦Ó§Aªº
    ²Ä21´Á = RrngA ¡F01,02 = CrngA=2 (Äæ)
    ¦b¦¹¤§ 01,02 = CrngA=2 (Äæ) «üªº¬O 01 (BÄæ¦ì­È),02 (CÄæ¦ì­È)
    Á`¦@¦³¨â­ÓÄæ¦ì¡H ¬°¦ó­n¨ú 01,02¡H ¬O¦]¬° CrngA «ü©w "1-2" ("B"¡B"C"Äæ)¡H
    ¦P²z
    RrngB = "18-21" «üªº¬O ²Ä18´Á¨ì²Ä21´Á¤§´Á¼Æ¡A¦¹¶µ¥ç¤wµL±e¸mºÃ¡C
    CrngB = "1-2"¡A ¦ý¬O§Aªº»¡©ú
    ²Ä18´Á = RrngB ¡F30 = CrngB=1 (Äæ)
    18      12   15   21   23   30   48   26
    ¬°¦ó¬O¨ú²Ä¤­¦ì (FÄæ) ªº 30¡A ¥B«ü©w¤§ CrngB=1 ¡H ¦Ó§Aªº»¡©ú¬O
    ©Ò¥H~ A°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X = ·í´Á (21´Á) ²Ä¤@¦ì (BÄæ) ¥X 01, ²Ä¤G¦ì (CÄæ)¥X 02¡F
    ¨ä¤W3´Á (18´Á) ²Ä¤­¦ì (FÄæ) ¥X 30 ¡H  
    30 ¬O®Ú¾Ú¬Æ»ò¼Æ¾Ú¥X½uªº¡A¦b§A«ü©wªº Number = "3,11,21-26,43,49" ¤¤¨Ã¤£¦s¦b 30 ³o¼Æ¦r¡H
B.  RrngA¨ìNrange=21´Á¨ì28´Á=Nrange-RrngA=7 ³o­Ó»P NUM=15 ~~ :
    ±NDATA!ªº(Nrange-NUM)¨ìNrangeªºA¡JH¶}¼úª©´Á¼Æ½Æ»s¶K¤WSheet1!A7 ªºªí¹F¦³¦ó¤£¦P¡H
C.  ±µ¤U¨Ó¡A ·í´Á (17´Á) ²Ä¤@¦ì (BÄæ) ¥X01, ²Ä¤G¦ì (CÄæ) ¥X02¡F¨ä¤W3´Á (14´Á) ²Ä¤­¦ì (FÄæ)
    ¥X30=A*B°ò·Ç²Õ¦X²Ä1­ÓÅçÃÒª©=17-12+14-5
    ¬°¦ó¤S«ü¦V 17´Á (RrngA = "21-24"¡ARrngB = "18-21")¡H "¨ä¤W3´Á" ¨ä¤¤ªº 3 ¬O "©T©w­È" ¶Ü¡H
    ¦p¬O¡A¨º¦b¦ó³B©w¸q¡H ¤S¡B¦¹³B 17-12+14-5 ªº§t·N¬O¡H ©¹¤U¤§ (14´Á)¡B(5´Á) ¥ç¦P¦¹°Ý¡C

ÁÂÁ§Aªº­@¤ß¦^ÂСI

TOP

¦^´_ 21# c_c_lai
A.
²Ä21´Á = RrngA ¡F01,02 = CrngA=2 (Äæ)
    ¦b¦¹¤§ 01,02 = CrngA=2 (Äæ)

CrngA=1-2·N«ü¦b°ò·Ç¦CAªº7Ä椤¥ô¨ú1Äæ©M7Äæ¥ô¨ú2Äæ¡F©Ò¥H¥»¨Ò´N¬O¦b°ò·Ç¦CA(=21´Á)¨úBÄæ=01©MCÄæ=02¡F¦X¬°"°ò·ÇA²Õ¦X"¡C
µM«á©¹¤W·j´M²Ä¤@¦¸¦P¼Ë¬OBÄæ=01©MCÄæ=02ªº´Á¼Æ¬°²Ä1­ÓA²Õ¦XÅçÃÒª©¡F²Ä¤G¦¸¦P¼Ë¬OBÄæ=01©MCÄæ=02ªº´Á¼Æ¬°²Ä2­ÓA²Õ¦XÅçÃÒª©¡F¨ä¾l...¥H¦¹Ãþ±À¡C

¦P²z
    RrngB = "18-21" «üªº¬O ²Ä18´Á¨ì²Ä21´Á¤§´Á¼Æ¡A¦¹¶µ¥ç¤wµL±e¸mºÃ¡C
    CrngB = "1-2"¡A ¦ý¬O§Aªº»¡©ú
    ²Ä18´Á = RrngB ¡F30 = CrngB=1 (Äæ)

30 ¬O®Ú¾Ú¬Æ»ò¼Æ¾Ú¥X½uªº¡A¦b§A«ü©wªº Number = "3,11,21-26,43,49" ¤¤¨Ã¤£¦s¦b 30 ³o¼Æ¦r¡H
¦P²z
¦b°ò·Ç¦CBªº7Ä椤¥ô¨ú1Äæ¡F¥»¨Ò´N¬O°ò·Ç¦CB(=18´Á)¨úFÄæ=30¡F¦X¬°"°ò·ÇB²Õ¦X"¡C
µM«á©¹¤W·j´M²Ä¤@¦¸¦P¼Ë¬OFÄæ=30ªº´Á¼Æ¬°²Ä1­ÓB²Õ¦XÅçÃÒª©¡F²Ä¤G¦¸¦P¼Ë¬OFÄæ=30ªº´Á¼Æ¬°²Ä2­ÓB²Õ¦XÅçÃÒª©¡F¨ä¾l...¥H¦¹Ãþ±À¡C
¦P²z
°ò·ÇA²Õ¦X*°ò·ÇB²Õ¦X=(²Ä21´ÁªºBÄæ=01©MCÄæ=02)*(=18´ÁªºFÄæ=30)
µM«á©¹¤W·j´M²Ä¤@¦¸¦P¼Ë¬OBÄæ=01©MCÄæ=02ªº´Á¼Æ¥B¨ä¤W3´ÁªºFÄæ=30¬°²Ä1­ÓA*B²Õ¦XÅçÃÒª©¡F
²Ä¤G¦¸¦P¼Ë¬OBÄæ=01©MCÄæ=02ªº´Á¼Æ¥B¨ä¤W3´ÁªºFÄæ=30¬°²Ä2­ÓA*B²Õ¦XÅçÃÒª©¡F¨ä¾l...¥H¦¹Ãþ±À¡C

30 ³o¼Æ¦r©M«ü©wªº Number = "3,11,21-26,43,49" µLÃö¡C

B.  RrngA¨ìNrange=21´Á¨ì28´Á=Nrange-RrngA=7 ³o­Ó»P NUM=15 ~~ :
    ±NDATA!ªº(Nrange-NUM)¨ìNrangeªºA¡JH¶}¼úª©´Á¼Æ½Æ»s¶K¤WSheet1!A7 ªºªí¹F¦³¦ó¤£¦P¡H

RrngA¨ìNrange=21´Á¨ì28´Á=Nrange-RrngA=7
7¬O«ü°ò·Ç¦CAªº´Á¼Æ¨ìNrange´Á¼Æªº´Á¶Z¡C
©Ò¥H¨äÅçÃÒª©¦P¼Ë¬O©¹¤U7´Á¨Ó¹ïÀ³¡C

NUM=XX~~¬O«ü©w´Á¶Z´Á¼Æ¡C
·íNUM=15¡F§Y¬O®ÄªGÀÉ®×Sheet1!A7:H22=DATA!A&Nrange-NUM+1:H&Nrange+1

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

½Ð°Ñ¦Ò¤W­zªº°ò·ÇA²Õ¦X*°ò·ÇB²Õ¦X»P¨äÅçÃÒª©ªº·j´MÅÞ¿è¡C

TOP

¦^´_ 22# ziv976688
¤£¦n·N«ä¡A¼Ó¤WªººÃ°Ý¡A©|¥¼©ú½T¸Ñµª¡C
A.  ²Ä18´Á = 18      12   15   21   23   30   48   26
    ¬°¦ó¬O¨ú²Ä¤­¦ì (FÄæ) ªº 30¡A ¦Ó«D¨ä¥L¼Æ¾Ú¡H
    ¦P¼Ëªº¡A
    ²Ä21´Á = 21      01   02   11   26   38   43   04
    ¬°¦ó­n¨ú 01,02¡A ¦Ó«D¨ä¥L¼Æ¾Ú¡H

    P.S.  «D¥H¦×²´¨Ó§PÂ_¡AÀ³¥H¤@¦X²zµ{¦¡ÅÞ¿è¨Ó°µ§PÂ_¡C
   
B.  RrngA¨ìNrange=21´Á¨ì28´Á=Nrange-RrngA=7  (28 - 21 = 7)
    7 ¬O«ü °ò·Ç¦CA ªº´Á¼Æ¨ì Nrange ´Á¼Æªº´Á¶Z¡C
    ©Ò¥H¨äÅçÃÒª©¦P¼Ë¬O ©¹¤U7´Á ¨Ó¹ïÀ³¡C

    NUM=XX~~¬O«ü©w´Á¶Z´Á¼Æ¡C
    ·íNUM=15¡F§Y¬O®ÄªGÀÉ®×Sheet1!A7:H22=DATA!A&Nrange-NUM+1:H&Nrange+1
   
    B1.  ¨ä¤¤¡A A7:H22 ¬O®Ú¾Ú¬Æ»ò¦Ó¨Ó¡H
    B2.  A&Nrange (28) - NUM (15) + 1 : H&Nrange (28) + 1¡A §Y A14:H29 ¡H

C.  "¨ä¤W3´Á" ¨ä¤¤ªº 3 ¬O "©T©w­È" ¶Ü¡H
    ¦p¬O¡A¨º¦b¦ó³B©w¸q¡H

    ±µ¤U¨Ó¡A ·í´Á (17´Á) ²Ä¤@¦ì (BÄæ) ¥X01, ²Ä¤G¦ì (CÄæ) ¥X02¡F¨ä¤W3´Á (14´Á) ²Ä¤­¦ì (FÄæ)
    ¥X30=A*B°ò·Ç²Õ¦X²Ä1­ÓÅçÃÒª©=17-12+14-5

    ®Ú¾Ú¬Æ»ò©w¸q¡A¬°¦ó¤S«ü¦V 17´Á (RrngA = "21-24"¡ARrngB = "18-21")¡H
    ©¹¤U¤§ (14´Á)¡B(5´Á) ¥ç¦P¦¹°Ý¡C
    ¤S¡B¦¹³B 17-12+14-5 ªº§t·N¬O¡H

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-11 19:56 ½s¿è

¦^´_ 23# c_c_lai
Exposition(0111).rar (6.8 KB)
§Ú·Q±z¬O»~±N°ò·Ç²Õ¦X©MÅçÃÒª©²Õ¦Xµø¬°¦P¤@­Ó¼Ðªº¤F^^

¶ñ¤JRrngA InputBox¸Ìªº´Á¼Æ¡A³£¬O«ü°ò·Ç´Á¼ÆA
¶ñ¤JCrngA InputBox¸ÌªºÄæ¦ì¼Æ¡A³£¬O«ü°ò·Ç´Á¼ÆAªºÄæ¦ì­Ó¼Æ
½Ð°Ñ¦Ò10#ªº»¡©ú¡C

©Ò¥H¡JRrngA=21-24  ¡F  CrngA=1-2
·N«ü
²Ä21´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺A°ò·Ç²Õ¦X
²Ä22´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺A°ò·Ç²Õ¦X
²Ä23´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺A°ò·Ç²Õ¦X
²Ä24´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺A°ò·Ç²Õ¦X
§Y¨C³æ´Á¦³7+21=28­Ó°ò·Ç²Õ¦X

¦]¦¹¤]¥i¥H¨úRrngA=24´ÁªºCrngA=1¤§ DÄæ(=21)¬°A°ò·Ç²Õ¦X¡A
µM«á~
©¹¤W·j´M²Ä¤@¦¸DÄæ=21ªº´Á¼Æ(=²Ä22´Á)¬°²Ä1­ÓÅçÃÒª©¡F±µµÛ¥H22+(Nrange-RrngA)=²Ä26´Á(¶}03,11,42,45,46,49,21)

µM«á~
¦A©¹¤W·j´M²Ä¤G¦¸DÄæ=21ªº´Á¼Æ(=²Ä20´Á)¬°²Ä2­ÓÅçÃÒª©¡F±µµÛ¥H20+(Nrange-RrngA)=²Ä24´Á(¶}11,17,21,26,43,49,03)

¦¹®É¡A¦]¬°¤G¦¸ªºÅçÃÒª©³£¦³¥X²{¬Û¦Pªº«ü©w¸¹½X=03,11,21,49¡A©Ò¥HA°ò·Ç²Õ¦XªºÅçÃÒª©²Å¦XNcount=2

¦P²z
RrngB=18-21  ¡F  CrngB=1-2
·N«ü
²Ä18´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺B°ò·Ç²Õ¦X
²Ä19´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺B°ò·Ç²Õ¦X
²Ä20´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺B°ò·Ç²Õ¦X
²Ä21´Áªº¥ô¨ú1Äæ©M¥ô¨ú2Ä檺B°ò·Ç²Õ¦X
§Y¨C³æ´Á¦³7+21=28­Ó°ò·Ç²Õ¦X

¦]¦¹¤]¥i¥H¨úRrngB=19´ÁªºCrngB=1¤§DÄæ(=17)¬°B°ò·Ç²Õ¦X¡A
µM«á~
©¹¤W·j´M²Ä¤@¦¸DÄæ(=17)ªº´Á¼Æ(=²Ä17´Á)¬°²Ä1­ÓÅçÃÒª©¡F±µµÛ¥H17+(Nrange-RrngB)=²Ä26´Á(¶}03,11,42,45,46,49,21)

µM«á~
¦A©¹¤W·j´M²Ä¤G¦¸DÄæ(=17)ªº´Á¼Æ(=²Ä15´Á)¬°²Ä2­ÓÅçÃÒª©¡F±µµÛ¥H15+(Nrange-RrngB)=²Ä24´Á(¶}11,17,21,26,43,49,03)

¦¹®É¡A¦]¬°¤G¦¸ªºÅçÃÒª©³£¦³¥X²{¬Û¦Pªº«ü©w¸¹½X=03,11,21,49¡A©Ò¥HB²Õ¦XªºÅçÃÒª©²Å¦XNcount=2


³Ì«á¦A¥H¤W­zªºA&B°ò·Ç²Õ¦X~¥H¦P¼ËÅÞ¿è·j´MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦XªºNcount=2ªºÅçÃÒª©²Õ¦X~~
¤W­zªºA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X=24´ÁªºDÄæ(=21)*¨ä¤W5´Á=19´ÁªºDÄæ(=17)
«h¥Ñ24´Á
©¹¤W·j´M²Ä¤@¦¸DÄæ(=21)¥B¨ä¤W5´ÁªºDÄæ(=17)¤§´Á¼Æ(=²Ä22´Á©M17¨ä)¬°²Ä1­ÓÅçÃÒª©¡F±µµÛ¥H22+(Nrange-RrngA)=²Ä26´Á(¶}03,11,42,45,46,49,21)
µM«á~
¦A©¹¤W·j´M²Ä¤G¦¸DÄæ(=21)¥B¨ä¤W5´ÁªºDÄæ(=17)¤§´Á¼Æ(=²Ä20´Á©M15´Á)¬°²Ä2­ÓÅçÃÒª©¡F±µµÛ¥H20+(Nrange-RrngA)=²Ä24´Á(¶}11,17,21,26,43,49,03)

¦¹®É¡A¦]¬°¤G¦¸ªºÅçÃÒª©³£¦³¥X²{¬Û¦Pªº«ü©w¸¹½X=03,11,21,49¡A©Ò¥HA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦XªºÅçÃÒª©²Å¦XNcount=2

·íNrange(=28)>RrngA(=24)> RrngB(=19)¡FCrngA=1¡FCrngB=1¡F Ncount=2¡F
¨äA°ò·Ç²Õ¦XªºÅçÃÒª©©MB°ò·Ç²Õ¦XªºÅçÃÒª©©MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦XªºÅçÃÒª©¡A
³£¦³¬Û¦Pªº«ü©w¸¹½X®É¡A«h²£¥Í®ÄªGÀÉ®×~~
¦WºÙ¡JI_28´Á_15_24-3+19-3_2¦¸_03,11,21,49
¤u§@ªí(Sheet1)ªº¤º®e»P®æ¦¡¡A¤£¦AÂØ­z¡C
======================================================================
Âç²M°ò·Ç²Õ¦X©MÅçÃÒª©ªº¤À§O¤ÎÅçÃÒª©ªº·j´MÅÞ¿è«á¡A¨ä¾lªº´N¬O³Ñ¤U~~
Á`¸ê®Æ§¨¡A¤l¸ê®Æ§¨¡A®ÄªGÀÉ®×µ¥¦WºÙªº«Ø¥ß¡J

¸ê®Æ§¨©MÀɮצWºÙ¤£¯à¥]§t*¦r¤¸¡A©Ò¥H§ï¬°+¥N´À)
Á`¸ê®Æ§¨¡JI_Nrange´Á_NUM_ RrngA _ CrngA¬P+RrngA _ CrngA¬P_ Ncount¦¸_ Number

¤À¸ê®Æ§¨¦WºÙ¡J(EX¡J¥»·s¼W½d¨Ò©Ò¦s©ñ¦ì¸mªº¤l¸ê®Æ§¨)¡JI_28´Á_15_24-1¬P+19-1¬P_2¦¸_ Number

®ÄªGÀɮסJ(EX¡J¥»·s¼W½d¨Ò)I_28´Á_15_24-3+19-3_2¦¸_03,11,21,49   
PS¡J®ÄªGÀɮצWºÙ¤¤ªºXX-3+XX-3¡F¨ä3¬°Äæ¦ì¶¶§Ç¡C
EX¡JBÄæ=1¡ACÄæ=2¡ADÄæ=3¡AEÄæ=4¡A FÄæ=5¡AGÄæ=6¡AHÄæ=7
    B&CÄæ=12¡AB&DÄæ=13¡AD&EÄæ=34¡AE&HÄæ=47¡FB&F&HÄæ=157¡A...¨ä¾lÃþ±À

Exposition(0111).rar (7.11 KB)

TOP

¦^´_ 23# c_c_lai
¦Aµy§@¸É¥R¡J
1_©Ò¦³InputBox¸Ìªº¼Æ¦r¡A³£¬O¥H¤H¤uÁä¤J¡C

2_A°ò·Ç²Õ¦X©MB°ò·Ç²Õ¦X©MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦Xªº¦UÅçÃÒª©¤§³Ì«á¤@¦C(§YNrange´Á¼Æªº¦U¹ïÀ³´Á¼Æ)¡A³£¥²¶·¦³Åã¥Ü¬Û¦Pªº«ü©w¸¹½X®É¡A¤~·|¦¨¥ß®ÄªGÀÉ®×(¨ä¤º¥u¦³¤@­Ó¤u§@ªí¡JSheet1)¡C

3_¦]¬°¬OA°ò·Ç²Õ¦X©MB°ò·Ç²Õ¦X©MA°ò·Ç²Õ¦X*B°ò·Ç²Õ¦X¦U¨Ì¾ÚÅÞ¿è¿z¿ï²Å¦X±ø¥óªºÅçÃÒª©²Õ¦X¡A©Ò¥HRrngA¡FCrngA¡FRrngB¡FCrngBªºInputBox¡A¦pªG¦³³]­p¤£·í©Î¤£¨¬ªº¦a¤è~~
©|½Ð±z¤£§[«ü¥¿¡CÁÂÁ±z!

TOP

¦^´_ 25# ziv976688
³o¬O§Ú®Ú¾Ú§Aªº¦^Âоã²z¥X¨Óªº
·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦X.rar (1.85 MB)
¸g¹L¾ã²z«á¡A°ò¥»¤W·~¤w¤j­P©úÁA§Aªº´y­z¡A
§A¦AÀ°§Ú­×¹¢¤@¤U¡AÅý§Ú¯à§ó½T¤Á¦a§ì¨ì­«ÂI¡A
ÁÂÁ§A­@¤ß¦a¸Ñ»¡¡I

TOP

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

¦^´_ 26# c_c_lai
±z«È®ð¤F!±z¾ã²z±o¤ñ¤£¤~ªº»¡©ú­ì½Z²M·¡©öÀ´¡A¤×¨ä¬O¹Ï¥Üªº³¡¤À¡C

µy·L¦A±j½Õ¤@­Ó­«ÂI~~
¦]¾ã­Ó½g´T³£¬O°Q½×²Å¦XÅÞ¿è±ø¥óªº²Õ¦X¡A©Ò¥H±j½Õ¤@¤U¤£²Å¦XÅÞ¿è±ø¥óªº±¡ªp~~
1_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X®É¡A´NµL»Ý¦A©¹¤WÄ~Äò·j´M¤F~³o­ÓA°ò·Ç²Õ¦X¬°µL®Ä²Õ¦X¡C

2_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X¡A
«h¦A©¹¤W·j´M¨ì²Ä¤G¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä2­ÓÅçÃÒ²Õ¦X~~
·í²Ä2­ÓÅçÃÒ²Õ¦X¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü»P²Ä1­ÓÅçÃÒ²Õ¦Xªº«ü©w¸¹½X¬Û¦P®É~~«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Ä²Õ¦X¡C

TOP

¦^´_ 27# ziv976688
ÁÂÁ§A¡A³o¦¸ªº¸É¥Rªº½T¬O§â­«ÂI (Key Point)
«ü¥X¨Ó¤F¡A§_«h¦b§PÂ_¤W·|¦³·¥¤jªº»~®t¡C
§Ú·|¦A¾ã­Ó«ä¦Ò¤@¤U¡C
3232323.png
2017-1-13 10:01

A.png
2017-1-13 10:01

B.png
2017-1-13 10:02

¥H¤W¤T­Ó¹Ï¥Ü¡A²Ä3­Ó A²Õ¦X*B²Õ¦XÅçÃÒª©¤§ "³Ì«á¤@¦C"
À³¥H¦óªÌ´Á¼Æ·í°µ¬°¥¿½Tªº "³Ì«á¤@¦C" ¡H

TOP

¦^´_ 25# ziv976688

¦A½Ð±Ð¥H¤U°ÝÃD¡A
°²³]¡G
RrngA = "22-26"
CrngA = "1-2"
RrngB = "20-24"
CrngB = "1-2"
Ncount = "2-3"

¦¹³B¤§ CrngA = "1-2" «üªº¬O "B"¡B"C" Äæ¡A
¦p¬° CrngA = "4-5"  «üªº¬O "E"¡B"F" Äæ ¡H

Ncount = "2-3" «üªº¬O "ÅçÃÒª©ªº³sÄò¦¸¼Æ"¡A
¦¹³B³sÄò¦¸¼Æ¬O»¡ "¤G¦¸" ¨ì "¤T¦¸"¡A¥ç§Y
¥»®×¨Ò¦³¨â­Ó°õ¦æ¤è®×µª®×¡G
¤@­Ó¬O "¤G¦¸"¡B¥t¤@­Ó¬O "¤T¦¸"¡H
¨º»ò¡A RrngA = "22-26" ¥ç¦P¦¹·NËç¡H

TOP

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

¦^´_ 28# c_c_lai
¥H¤W¤T­Ó¹Ï¥Ü¡A²Ä3­Ó A²Õ¦X*B²Õ¦XÅçÃÒª©¤§ "³Ì«á¤@¦C"
À³¥H¦óªÌ´Á¼Æ·í°µ¬°¥¿½Tªº "³Ì«á¤@¦C" ¡H

7+5=12(²Ä3­Ó A²Õ¦X*B²Õ¦XÅçÃÒª©¤§ "³Ì«á¤@¦C")~~¦]¬°A*BªºÅçÃÒªO²Õ¦X¬O¥ÑA°ò·Ç²Õ¦X©¹¤W·j´M(§Y·j´M½d³ò¬O¥ÑA°ò·Ç²Õ¦X-1ªº´Á¼Æ(§t)¡A©¹¤W·j´M)
EX:¥»¨ÒªºA²Õ¦X*B²Õ¦XÅçÃÒª©¬O¥Ñ~~
A°ò·Ç²Õ¦X-1ªº²Ä22´Á(§t)¡A©¹¤W·j´M²Ä1¦ì(BÄæ)¶}02¡A²Ä2¦ì(CÄæ)¶}12¥B¨ä¤W2´Áªº²Ä1¦ì(BÄæ)¶}01¡A²Ä2¦ì(CÄæ)¶}02ªº¦PÄæ¦ì¥B¦P¸¹½X°¦²Ä1­Ó¨ì²Ä3­Óªº¬Û¦P²Õ¦X(§YÅçÃÒªO²Õ¦X)¡C
==================================================================
¦A¨Ì¶¶§Ç­«·s¾ã²zÃö©ó¤£²Å¦XÅÞ¿è±ø¥óªº±¡ªp~~
1_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M~³£¨S¦³·j´M¨ì¥ô¦ó¦PÄæ¦ì¦P¸¹½XªºÅçÃÒ²Õ¦X¡A«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº°ò·Ç²Õ¦X¡C

2_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X®É¡A´NµL»Ý¦A©¹¤WÄ~Äò·j´M¤F~³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C

3_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X¡A
«h¦A©¹¤W·j´M¨ì²Ä¤G¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä2­ÓÅçÃÒ²Õ¦X~~
3a_·í·j´M¤£¨ì²Ä2­ÓÅçÃÒ²Õ¦X®É~~«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C  
3b_·í¦³·j´M¨ì²Ä2­ÓÅçÃÒ²Õ¦X¡A¦ý¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü»P²Ä1­ÓÅçÃÒ²Õ¦X¬Û¦Pªº«ü©w¸¹½X®É~~«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C

¥H¤W¬ONcount =2®Éªº¤£²Å¦XÅÞ¿è±ø¥óªº±¡ªp¡C

¥H¤U¬ONcount =3®Éªº¤£²Å¦XÅÞ¿è±ø¥óªº±¡ªp¡C

1_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M~³£¨S¦³·j´M¨ì¥ô¦ó¦PÄæ¦ì¦P¸¹½XªºÅçÃÒ²Õ¦X¡A«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº°ò·Ç²Õ¦X¡C

2_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X®É¡A´NµL»Ý¦A©¹¤WÄ~Äò·j´M¤F~³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C

3_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X¡A
«h¦A©¹¤W·j´M¨ì²Ä¤G¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä2­ÓÅçÃÒ²Õ¦X~~
3a_·í·j´M¤£¨ì²Ä2­ÓÅçÃÒ²Õ¦X®É~~«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C  
3b_·í¦³·j´M¨ì²Ä2­ÓÅçÃÒ²Õ¦X¡A¦ý¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü»P²Ä1­ÓÅçÃÒ²Õ¦X¬Û¦Pªº«ü©w¸¹½X®É~~«h³o­ÓA°ò·Ç²Õ¦X¬°µL®Äªº²Õ¦X¡C

4_·í¥Ñ¬Y­ÓA°ò·Ç²Õ¦X©¹¤W·j´M¨ì²Ä¤@¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä1­ÓÅçÃÒ²Õ¦X¡A¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)¦³Åã¥Ü¥ô¤@­Ó«ü©w¸¹½X¡A
«h¦A©¹¤W·j´M¨ì²Ä¤G¦¸¦PÄæ¦ì¦P¸¹½Xªº²Ä2­ÓÅçÃÒ²Õ¦X~~·í²Ä2­ÓÅçÃÒ²Õ¦X»P²Ä1­ÓÅçÃÒ²Õ¦Xªº³Ì«á¤@¦C¤]¦³Åã¥Ü¬Û¦Pªº«ü©w¸¹½X®É~~
4a_·í·j´M¤£¨ì²Ä3­ÓÅçÃÒ²Õ¦X®É~~«h³o­ÓA°ò·Ç²Õ¦X¦bNcount =3®É~~¬°µL®Äªº²Õ¦X¡C  
3b_·í¦³·j´M¨ì²Ä3­ÓÅçÃÒ²Õ¦X¡A¦ý¨ä³Ì«á¤@¦C(=Nrange´Á¼Æªº¹ïÀ³´Á¼Æ)³£¨S¦³Åã¥Ü»P²Ä1­ÓÅçÃÒ²Õ¦X©M²Ä1­ÓÅçÃÒ²Õ¦X¬Û¦Pªº«ü©w¸¹½X®É~~«h³o­ÓA°ò·Ç²Õ¦X¦bNcount =3®É~~¬°µL®Äªº²Õ¦X¡C

¨ä¾lNcount =4~10¥H¦¹Ãþ±À¡C

¥t¥~´£¿ô:Number InputBox¶ñ¤Jªº¼Æ¦r½d³ò=1~49¡A¨ä¥i¶ñ¤J¶µ¥Ø«¬ºA¥i¬°³æ¶µ¦¡©Î¦h¶µ¦¡©Î©Î²V©M¦¡µ¥½Æ¦X¦¡~~
EX:
¥i¶ñ¤J¥ô¤@­Ó³æ¿Wªº¼Æ¦r(EX:1©Î3©Î4©Î...,©Î49)¡F
¤]¥i¶ñ¤J¥ô¤@­Ó³æ¿Wªº³sÄò¼Æ¦r(EX:1-3©Î5-6©Î10-15©Î...,©Î41-49)¡F
¤]¥i¶ñ¤J¦h­Óªº³æ¿W¼Æ¦r(EX:1,3,5©Î2,4,6,8©Î...,©Î1,7,10,15,20,30,35,42,49)¡F
¤]¥i¶ñ¤J³æ­Óªº³sÄò¼Æ¦r(EX:1-5©Î2-8©Î...,©Î40-49©Î1-49)¡F
¤]¥i¶ñ¤J¦h­Óªº³sÄò¼Æ¦r(EX:1-5,7-10©Î2-8,20-25,©Î...,©Î2-5,10-18,20-22,30-33,45-49)¡F
¤]¥i¶ñ¤J¥ô¤@­Ó³æ¿Wªº¼Æ¦r©M³æ¿W³sÄò¼Æ¦r(EX:1,5-6©Î10,13-15©Î...,©Î20,41-49)¡F
¤]¥i¶ñ¤J¦h­Ó³æ¿Wªº¼Æ¦r©M¦h­Ó³sÄò¼Æ¦r(EX:1,3,5-6©Î10,13-15,20,23,26,30-33©Î...,©Î1-5,10,13,20,30-33,40,45-49)¡F

³sÄò¸¹½X¥H"-"ªí¥Ü¡F¶µ¥Ø»P¶µ¥Ø¤§¶¡¥H","¶¡¹j¡C

¨ä¥¦ªº InputBox¶ñ¤Jªº¼Æ¦r½d³ò=¨Ì¨ä«á­±ºñ¦r»¡©ú¡A¨ä¥i¶ñ¤J¶µ¥Ø«¬ºA¥i¬°³æ¶µ¦¡©Î¦h¶µ¦¡©Î©Î²V©M¦¡µ¥½Æ¦X¦¡
P.S.«á­±ºñ¦r¨S¦³µù°O»¡©úªº~~¨ä½d³ò~~StrRng=1~9999¡FNrange=2~9999¡F¥B­n>StrRng¡Fnum =2~9999¡F RrngA=3~9999¥B­n<Nrange¡FRrngB=2~9999¥B­n<RrngA¡C

¥H¤W  ÂԽаѦÒ!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD