- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-15
|
¦^´_ 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 |
|