­ã´£³¡ªL

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

­ã´£³¡ª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¦³¦ó§@¥Î???

­ã´£³¡ª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)

­ã´£³¡ªL

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

­ã´£³¡ªL

¦^´_ 10# Airman


¥Î¢Ô¢¸¬Ý¤@¬Ý¤U¤è¤½¦¡ªº®t²§¡G
=OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),ROW($1:$7))=$R$5
=N(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),ROW($1:$7)))=$R$5
=N(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),1,,7))=$R$5
=COUNTIF(OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),1,,7),$R$5)

­ã´£³¡ªL

¦^´_ 13# Airman


³o­Ó¤½¦¡¬O¿ù»~ªº,
RANK ¥u·|¥X²{ [¼Æ­È]¤Î[¿ù»~­È], ¥Î N¦æ¤£³q(µLªk±Æ¿ù), ª½±µCOUNT§Y¥i,

­ã´£³¡ªL

¦^´_ 15# Airman


¥HSheet3. T35¬°¨Ò¡G
=IF(L_1,"",IF(MODE(N(OFFSET($I$6,CHOOSE({1;2;3},$R35,$R35-T$3,$R35-T$3*2),{1,2,3,4,5,6,7})),0,0,0)*(COUNT(N(RANK($R$5,OFFSET($I$6,CHOOSE({1,2,3},T$5,T$5-T$3,T$5-T$3*2),1,,7)))=3)),$R35-T$3*2,""))¡@

®Ø¦í¬õ¦â¬q«ö¢Ô¢¸¬Ý¬Ý¡A­È¬°¢¯¡A±ø¥ó¬O¤£¦¨¥ßªº¡I¡]¦ýµª®×¬Ý¨Ó¨S¿ù¡AÀ³¬O»~¼²¡A¦h¤@¨Ç´ú¸Õ­È¤~·Ç¡^


=IF(L_1,"",IF(MODE(N(OFFSET($I$6,CHOOSE({1;2;3},$R35,$R35-T$3,$R35-T$3*2),{1,2,3,4,5,6,7})),0,0,0)*(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),$R35-T$3*2,""))


ÂŦâ¬q­È¬°TRUE¡I
ª`·N¡G³o¤½¦¡À³¥H¡e°}¦C¡f¿é¤J¡I