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

[µo°Ý] ¨ç¼Æ_¦h­Ó«ü©w´Á¼Æ¦³¤@­Ó(§t)¥H¤Wªº¥æ¶°­È¡C

[µo°Ý] ¨ç¼Æ_¦h­Ó«ü©w´Á¼Æ¦³¤@­Ó(§t)¥H¤Wªº¥æ¶°­È¡C

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-11-19 18:42 ½s¿è

°Ñ¦Òªþ¥ó¡Jhttp://www.FunP.Net/560821

¥H¤£¦A¼W¥[¦WºÙ©w¸q¬°­ì«h¡CÁÂÁÂ!

»¡©ú¡J
¦WºÙ©w¸q¡JR_R=$R7¡F T_3=T$3¡F T_5=T$5¡F  L_1==OR(T$5="",$R7="",$R7>=T$5,$R7-T$3*2<7)

Sheet1!T7
=IF(L_1,"",IF(MODE(SUMIF(OFFSET($I$6,CHOOSE({1;2;3},T$5,T$5-T$3,T$5-T$3*2),1,,7),$R$5,OFFSET($I$6,CHOOSE({1;2;3},$R7,$R7-T$3,$R7-T$3*2),1,,7)),0,0,0),$R7-T$3*2,""))

»Ý¨D¡JSheet2!T7
=T5©MT5-T3©MT5-T3*2¤T­Ó´Á¼Æ³£¦³R5­È¡F¥t¦b$R7,$R7-T$3,$R7-T$3*2¤T­Ó´Á¼Æ¦³¤@­Ó(§t)¥H¤Wªº¥æ¶°­È¡C
PS:¤G­Ó¬q¸¨µL¶·¦³¹ïÀ³Ãö«Y¡C

½Ð°Ý¡J
Sheet1!T7¤½¦¡ªºÂŦâ¬q¸¨­n¦p¦ó­×§ï¤~¯à²Å¦X»Ý¨D?

¸Ô²Ó»¡©ú¤Î¹Ï¥Ü¦pªþ¥ó¡C

¥H¤W  Àµ½Ð¦U¦ì¥ý¶i¡B«e½ú¤£§[½ç±Ð!  ÁÂÁÂ!

¢²¹ï¢²¡A³»¦h¹ïÀ³¥X¢²­Ó¼Æ¦r¡A¦p¦ó¥s¥æ¶°¡H
¯à§_¥Î¤WÃD§Ú°µªº¤è¦¡¡AÁ|¹ê¨Ò¤Î¬yµ{»¡©ú¡H

TOP

¦^´_ 2# ­ã´£³¡ªL
­ã¤j:
¨þ ~¨þ~¤p§Ì¦³¯S§Oµù©ú~¤G­Ó¬q¸¨µL¶·¦³¹ïÀ³Ãö«Y~©Ò¥H¥u°w¹ï¤T­Ó´Á¼ÆR7,R7-T3,R7-T3*2¦Ó¨¥:
90 { 09,12,17,28,39,43,07 }
81 { 01,07,13,39,42,45,49 }
72 { 07,09,14,20,21,39,49 }
¤T­Ó´Á¼Æ³£¦³(¥æ¶°)07,39¡C

TOP

¦^´_ 3# Airman


=IF(L_1,"",IF(MODE(N(OFFSET($I$6,CHOOSE({1;2;3},$R7,$R7-T$3,$R7-T$3*2),{1,2,3,4,5,6,7})),0,0,0),$R7-T$3*2,""))
=IF(L_1,"",IF(MODE(N(OFFSET($I$6,CHOOSE({1,2,3},$R7,$R7-T$3,$R7-T$3*2),ROW($1:$7))),0,0,0),$R7-T$3*2,""))

¤T°Ï¥ô¤@¬Û¦P, ¦¨¥ß~~

­ì¦¡ T$5,T$5-T$3,T$5-T$3*2 ¤S¦³¦ó§@¥Î???

TOP

¦^´_ 4# ­ã´£³¡ªL
­ã¤j:
¤T´Áªº¥æ¶°¤G­Ó¤½¦¡³£´ú¸ÕOK¤F~¦ý
T$5,T$5-T$3,T$5-T$3*2¤T­Ó´Á¼Æ¥²¶·³£­n¦³T5ªº¤½¦¡~
½Ð±Ð±z:­n«ç»ò®M¶i¥h?

¨þ~¨þ~Á`¤£¯à¦A¥[¼g3¦¸ OR¤½¦¡
*OR($R$5=OFFSET($I$6,T$5,1,,7))*OR(..,T$5-T$3,...)*OR(..,T$5-T$3*2,...)
¶}­Óª±¯º

TOP

¦^´_ 5# Airman

ÀË´ú¤T°Ï¦P®É§t¦³$R$5­È¡G
=MODE($R$5,0,0,0,0,N(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),ROW($1:$7))))
=AND(COUNTIF(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),1,,7),$R$5))
=(COUNT(RANK($R$5,OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),1,,7)))=3)

TOP

¦^´_ 6# ­ã´£³¡ªL
­ã¤j:
´ú¸ÕOK¤F!«D±`ÁÂÁ±z¦p¦¹­@¤ßªº«ü¾É¤F3­ÓÀË´ú¤½¦¡~¤£³Ó·P¿E

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-11-20 12:07 ½s¿è

¦^´_ 6# ­ã´£³¡ªL
­ã¤j:
½Ð±Ð±z:
²Ä¤@¦¡ªºMOD¨ç¼Æ¬°¦ó­n¥[4­Ó0~$R$5¤£¬O¥u¦³3­Ó´Á¼Æ¶Ü?
ÁÙ¦³¤p§Ì¤@ª½¹ïNªº·N«ä©M¥Îªk¤£ÁA¸Ñ~¥i§_³Â·Ð±z¥Î¥Õ¸Ü¤å»¡©ú¤@¤U~¦]¬°¬ÝF1ªº»¡©ú¡A¤p§Ì¤@ª½Ãú·Ù·Ù
ÁÂÁ±z

²Ä¤G,¤T¦¡¨S°ÝÃD~³£¤F¸Ñ¡C

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-11-20 13:16 ½s¿è

¦^´_ 8# Airman


=MODE($R$5,0,0,0,0,N(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),ROW($1:$7))))
MODE¨ú²³¼Æ¡A­Y¦³²Å¦XªÌ¥B¦³¦h­Ó¡A«h¨ú¥X³Ì¥ý¥X²{ªÌ¡A
¤§«e±N0,0,0©ñ¦b«á­±¡A§Y«e­±¦³¢²­Ó¬Û¦P¼Æ®É¡A«hÀu¥ý¨ú¤§¡F§_«h¥u¦³¢¯²Å¦X¢²­Ó¡A
¦¹¦¸±N$R$5©ñ¦b³Ì«e­±¡A°£«D«á­±¦³¢²­Ó»P$R$5¬Û¦P´ê¦¨¢³­Ó¡]«á­±¢²­Ó¬Û¦P¼Æ¤£¤@©w¬O$R$5¡^¡A§_«h¥u¦³0,0,0,0²Å¦X¢³­Ó¡I

N( )¡A
¹J¡e¤å¦r¡f¥H¢¯Åã¥Ü¡A
¹JTRUE,FALSE¡A¥H¢°¡A¢¯Åã¥Ü¡A
¦b OFFSET ¤W¡A­Y¨ç¼Æ¤£¦Y¡e¦ì§}°Ñ·Ó¡f¡A«h¶·¥Î¢Ü±N¨äÂন¡e¼Æ­È°}¦C¡f¡I
¨ä¥¦¶·¦Û¦æ¤@¤@¥h´¢¼Ò¡ã¡ã

¥i´ú¸Õ¥H¤U¤½¦¡¡G
=MODE(11,0,0,0,11,11,33)
=MODE(11,0,0,0,0,11,11,33)
=MODE(11,0,0,0,0,11,11,11)

TOP

¦^´_ 9# ­ã´£³¡ªL

­ã¤j:
·PÁ±z±NMODE¨ç¼Æ¤§¹B¥Îªk~§@¸Ô²Óªº»¡©ú~¤p§Ì¤F¸Ñ¤F~·P®¦

N( )¡A
¹J¡e¤å¦r¡f¥H¢¯Åã¥Ü¡A..........
¨ç¼Æ¤£¦Y¡e¦ì§}°Ñ·Ó¡f¡A«h¶·¥Î¢Ü±N¨äÂন¡e¼Æ­È°}¦C¡f¡I
­«ÂI»¡©ú¨ì¤F~À´¤F!
¨C¦¸¬Ý¨ìN®É¡AÁöµMF1»¡±o«Ü©ú¥Õ~¦ý©ú©ú´N¬O¨S¦³¥Î¨ì¤å¦r©Î¤é´Á°Ú!
¦p¤µ©ú¥Õ¬O¦]¬°¨ç¼Æ¤£¦Y¡e¦ì§}°Ñ·Ó¡fªºÃö«Y¡C
ÁÂÁ±zªº­@¤ß«ü¾É~¨ü¯q¨}¦h

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD