- ©«¤l
- 315
- ¥DÃD
- 51
- ºëµØ
- 0
- ¿n¤À
- 367
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2021-10-12
|
¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-20 12:06 ½s¿è
¦^´_ 2# ã´£³¡ªL
ã¤j:
³o¬O«e3¤j(§t71¦C¤]¬O¨ú¦PÄæ¹ïÀ³¼Æªº¸û¤jªÌ)ªº°}¦C¤½¦¡~
=SMALL(IF(MAX((LARGE((MATCH(OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),)=COLUMN($B:$AX)-1)*OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),COLUMN(A1))=OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49))*(OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49)/1%%+$B$71:$AX$71))=OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49)/1%%+$B$71:$AX$71,$B$1:$AX$1),MOD(ROW(A1),7))
¦p¦ó§ï¦¨«e3¤p(§t71¦C¤]¬O¨ú¦PÄæ¹ïÀ³¼Æªº¸û¤pªÌ)ªº¤½¦¡
¤p§Ì¦³±NMAX§ï¬°MIN¡FLARGE§ï¬°SMALL¡A¦ýµª®×Åܦ¨ªÅ¥Õ^^"
¤£ª¾¹DÁÙnקïþ¸Ì?
·q½Ð«ü±Ð©M½ç¥¿!ÁÂÁ±z^^ |
|