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

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

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

¦p¦ó­pºâ¥Xtrue¥X²{³sÄò¦¸¼Æ

¸ß°Ý.png
2017-4-28 14:53

²Î­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
¥¢±Ñ.png
2017-4-28 17:27

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
½Ð±Ð.png
2017-4-28 17:36

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD