Airman

¦^´_ 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

Airman

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

­ã´£³¡ªL

¦^´_ 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)

Airman

¦^´_ 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,...)
¶}­Óª±¯º

­ã´£³¡ªL

¦^´_ 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¦³¦ó§@¥Î???

Airman

¦^´_ 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

­ã´£³¡ªL

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