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

½Ð°Ý³o12¸Uµ§¸ê®Æ¸Ì­± §Ú­n¦p¦ó²Î­p "TRUE"³sÄò¥X²{ªº¦¸¼Æ

½Ð°Ý³o12¸Uµ§¸ê®Æ¸Ì­± §Ú­n¦p¦ó²Î­p "TRUE"³sÄò¥X²{ªº¦¸¼Æ


²Î­ptrueªº³sÄò¥X²{¦¸¼Æ.rar (370.14 KB)
½Ð¦U¦ìÀ°À°¦£ ÁÂÁÂ

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-4-28 16:32 ½s¿è

¥Î¦WºÙ©w¸q¤½¦¡
xT =FREQUENCY(ROW($1:$120000),ROW($1:$120000)*($A$1:$A$120000=FALSE))

³Ì¦h¥X²{³sÄò´X­Ó
=MAX(xT)-1


³sÄò¥X²{
D3:D32 =FREQUENCY(xT,MOD(ROW(2:30),29))
½d³ò°}¦C¤½¦¡
PS: ½Æ»s¤W­z¤½¦¡¡A¿ïD3:D32«á±N¤½¦¡¶K¤W½s¿è¦C¡A¥ý«öCTRL+SHIFT¤£©ñ¡A¦A«öENTER¿é¤J¤½¦¡¡A­Y¦¨¥\¤½¦¡«e«á·|¦³ {.....}

"´X­Ó"  C3¤U©Ô30­Ó
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
¤j¯« ©êºp «á½ú¤£§÷ xtªº·N«ä¬O  ÁÙ¦³³Ì¤j­Èªº·N«ä §Ú¬Ý¤£¤ÓÀ´

TOP

¦^´_ 3# eric7765

²Î­ptrueªº³sÄò¥X²{¦¸¼Æ.rar (372.03 KB)
¬Ý¬ÝÀɮ׸̪º¤½¦¡(¶À¦â°Ï)

¤u¨ã¦C¸Ì ¤½¦¡ - ¦WºÙºÞ²z­û¡A¬d¬Ý xT ¦WºÙ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

TOP

¦^´_ 4# ML089
«D±`·PÁ  ¥¿¦b¬ã¨s¤¤¤F

TOP

¦^´_ 2# ML089
¤j¯« ©êºp¦A¥´ÂZ±z¤@¤U ¶À¦â°Ï¶ô ¸Ì­±ªº¤½¦¡¬Ý°_¨Ó³£¤@¼Ë  ¬°¬Æ»òÅã¥Ü¥X¨Óªº­È·|¤£¤@¼Ë©O?
¦]¬°§ÚÁٻݭn®M¹D§Oªº¼Æ¾Ú¸Ì ©Ò¥H»Ý­n²z¸Ñ²M·¡¤@ÂI ¦A³Â·Ð¤j¯«¤F

TOP

¦^´_ 7# eric7765

½d³ò°}¦C¤½¦¡
PS: ½Æ»s¤W­z¤½¦¡¡A¿ïD3:D32«á±N¤½¦¡¶K¤W½s¿è¦C¡A¥ý«öCTRL+SHIFT¤£©ñ¡A¦A«öENTER¿é¤J¤½¦¡¡A­Y¦¨¥\¤½¦¡«e«á·|¦³ {.....}

¤@¯ë¤½¦¡¥Î ENTER¿é¤J
°}¦C¤½¦¡¥Î CTRL+SHIFT+ENTER ¤TÁä»ô«ö¿é¤J
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089
¦³¦¨¥\¤F §Ú¦A¦h½m²ß´X¦¸ ·P¿E
ÁÙ¦³·Q½Ð±Ð ²Ä 28­Ó¸ò29­Ó ¬°¬Æ»ò·|¦³¼Æ¦r©O? ¦]¬°³Ì°ª¤£¬O21­Ó¶Ü?

TOP

¦^´_ 9# eric7765


²Î­ptrueªº³sÄò¥X²{¦¸¼Æ_TEST.rar (7.44 KB)
¤p¸ê®Æ½m²ß¡A¬Ý¬Ý¤½¦¡¤¤FREQUENCY¨ç¼Æ¨C­Ó°Ñ¼ÆÅܤơA¥ý¦Û¦æÅé·|¡A¤£À´¦A°Ý¡C

²Ä¤@­Ó(¤º)FREQUENCY²Î­pªº¼Æ­n´î1¤~¬O³sÄò¼Æ
¦]¬°°}¦C¦³120000­Ó¤£·Q¥ý´î1¡A³o·|¼W¥[­pºâ®É¶¡¡A©Ò¥H¥Î¨ú2¥N´À1¡A¨ú3¥N´À2¡A¨Ó²Î­p³sÄò¼Æ¼Æ¶q
FREQUENCY ²Ä¤Gªº°}¦C¼Æ­È²Ä¤@­ÓÀ³¸Ó¬°2¶}©l(2,3,4,5,......,0,1)¡A³Ì«áÀ³¸Ó¥Î1¦¬§À¡A©Ò¥H¨Ï¥ÎMOD¨ç¼Æ¨Ó³B²z
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD