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

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

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

²Î­p¨C­Ó³sÄò¼Æ+1
xT =FREQUENCY(ROW($1:$120000),ROW($1:$120000)*($A$1:$A$120000=FALSE))

²Î­p¬Û¦Pªº³sÄò¼Æ¼Æ¶q
=FREQUENCY(xT,MOD(ROW(2:30),29))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
¤j¯«ª©¥D ¦]¬°¦³¦n´X­ÓÄæ¦ì»Ý­n­pºâ ±zªº¤èªk«Ü¦n¦ý¬OÅܦ¨§Ú¤£·|Âà´«¨ì§OÄæ ¦]¬°¤½¦¡¬Ý°_¨Ó¤@¼Ò¤@¼Ë¤£§÷ªº§ÚµLªk±ÀºâÅÞ¿è
±z¯à±Ð¾É§Ú ¦p¦ó­pºâ aÄæ©Ò¦³ªº true ³sÄò3¦¸ªº¦³´X­Ó  ³sÄò5¦¸ªº¦³´X­Ó  ³æ¯Â¤½¦¡  ³o¼Ë§Ú´N¥i¥H®{ªk·Ò¿ûºCºC¥Î¤F

TOP

¦^´_ 11# ML089
¤j¯«ª©¥D §Ú¶Ç§Ú³Ì«á·Q­n°µ¦¨ªºªí®æµ¹±z¬Ý¬Ý
¥Î°}¦Cªº¤è¦¡ ¦n¹³¨S¿ìªk§ïÅܤ@³¡¤Àªº¤½¦¡
±z¥i¥H¬Ý¬Ý³o­ÓÀÉ®× ±Ð¾É«á½ú¤@¤U¶Ü  §Ú¥i¥H¦Û¤vºCºC®M¶i¥h
¯uªº«D±`·PÁ±z



    TEST(true,false).rar (105.96 KB)

TOP

¦^´_ 13# eric7765

AÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(A2:A4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(A2:A4835<>FALSE)),MOD(ROW(2:33),32))

BÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(B2:B4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(B2:B4835<>FALSE)),MOD(ROW(2:33),32))

CÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(C2:C4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(C2:C4835<>FALSE)),MOD(ROW(2:33),32))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
¥Ø«e TRUEªº³¡¤À ¤w¸g¥i¥H¥H¦¹Ãþ±À ¦¨¥\¤F

·Q½Ð°Ý FALSEªº­pºâ¤è¦¡¤£¤@¼Ë¶Ü?
=FREQUENCY(ROW($1:$120000),ROW($1:$1000000)*($A$1:$A$1000000=FALSE))
§Ú§â¤W­±ªº FALSE´«¦¨TRUE ¥H¬°¥i¥Hºâ¥XFALSE ¦ý¬O¼Æ¦rºâ¥X¨Ó¬O¿ù»~ªº

TOP

¦^´_ 14# ML089
ÁÂÁª©¥D ¤w¸g¦¨¥\¤F ²{¦b³Ñ¤Uªº°ÝÃD¬O ¬°¤°»ò 28 29­Ó¨ºÃä·|¥X²{¼Æ¦r??

TOP

¦^´_ 14# ML089


ÁÂÁª©¥D ¤w¸gª¾¹D°ÝÃD¥X¦b­þ¸Ì¤F ¤]¤w¸g¸Ñ¨M§Úªº°ÝÃD «D±`·PÁ  ©P¥½´r§Ö

TOP

¦^´_ 14# ML089
¦A½Ð±Ð¤@°ÝÃD ¦pªG¤µ¤Ñ§Ú²Î­pªº¸ê®Æ ¦³10000µ§ ¨º§ÚÀ³¸Ó­n§ó§ï¨º¨Ç¼Æ¦r?  ³o­ÓÀÉ®×¥u¦³ 4835µ§¸ê®Æ

TOP

¦^´_ 1# eric7765


   
²Î­ptrue¦¸¼Æa.jpg
2017-4-28 22:44


²Î­ptrue¦¸¼Æb.jpg
2017-4-28 22:44
http://expresmile.teachable.com

TOP

¦^´_ 18# eric7765

¥H¤U¸ê®Æ¦ì©ó 2:4835¦C¡A­Y¦³ 10000µ§ªí¥Ü¸ê®Æ¦ì©ó 2:10001¡A±N
ROW(2:4835)§ï¬°ROW(2:1001)
A2:4835§ï¬°A2:A1001

AÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(A2:A4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(A2:A4835<>FALSE)),MOD(ROW(2:33),32))

BÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(B2:B4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(B2:B4835<>FALSE)),MOD(ROW(2:33),32))

CÄæ²Î­p
TRUE  =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(C2:C4835<>TRUE)),MOD(ROW(2:33),32))
FALSE =FREQUENCY(FREQUENCY(ROW(2:4835),ROW(2:4835)*(C2:C4835<>FALSE)),MOD(ROW(2:33),32))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD