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

[µo°Ý] ·j´M49Äæ*10¦C¤ñ¤j¤p

[µo°Ý] ·j´M49Äæ*10¦C¤ñ¤j¤p

¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-20 09:04 ½s¿è

´ú¸ÕÀÉ~ «e3¤p_0420.rar (27.22 KB)

³Æµù¡J
1_½Ð¥HMS2003ª©ªº¨ç¼Æ¸ÑÃD¡C
2_¤£¼W¥[»²§UÄ欰¸ÑÃD­ì«h¡C
3_¦USheetªº¤º®e¬Ò¬°¼ÒÀÀ¡C


»Ý¨D¡J
¥D±ø¥ó=·j´M$B7:$AX7ªº«e¤T¤p¼Æ¦r(¤¤¦¡±Æ¦W)¡F
¦pªG¥D±ø¥óªº«e¤T¤p¼Æ¦r¬O¬°³æ1­Ó®É¡A«h±N¨ä¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7¡C

°Æ±ø¥ó1=¦pªG¥D±ø¥ó¨ä¤¤ªº¬Y±Æ¦W¼Æ¡A¦³2­Ó(§t)¥H¤W®É¡A«h¿ï¨ú¨ä¦b$B71:$AX71ªº¦PÄæ¹ïÀ³¼Æ¦r¸û¤p¤§±Æ¦WªÌ¡A
¨Ã±N¿ï¨ú«áªº«e¤T¤p¼Æ¦r¤§¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7¡C

°Æ±ø¥ó2=¦pªG¥D±ø¥óªº¨ä¤¤¬Y±Æ¦W¼Æ¡A¦³2­Ó(§t)¥H¤W¡A¥B¨ä¦b$B71:$AX71ªº¦PÄæ¹ïÀ³¼Æ¦r¥ç¬Û¦P®É¡A«h±N¸Ó¬Û¦P±Æ¦WªÌ¥þ¿ï¨ú¡A
¨Ã±N¿ï¨ú«áªº«e¤T¤p¼Æ¦r¤§¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7¡C

¥H¤W   Àµ½Ð¦U¦ì¥ý¶i´f¤©½ç±Ð!ÁÂÁÂ!

¥»©«³Ì«á¥Ñ 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^^

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-20 16:28 ½s¿è

¦^´_ 4# ­ã´£³¡ªL
¦^´_ 5# ML089
·PÁ¤G¦ìª©¥D½ç±Ðªº°Ï°ì°}¦C¤½¦¡^^"
¥i¤£¥i¥H½Ð¤G¦ì±Ð¤p§Ì¦p¦ó­×§ï3#ªº¤@¯ë°}¦C¤½¦¡?
¦]¬°¤p§Ì¦h¦¸¦³½Ð±Ð¹L¸Ó¤½¦¡ªº­ì§@ªÌ¦p¦ó­×¥¿?¤]¤£ª¾¹D¬O¦³¤°»ò­ì¦]¡A¦³¦^ÂСA«oÁ`¬O±o¤£¨ì"¥¿½Tµª®×"ªº¦^ÂСC

¤£¬O¤p§Ì°õµÛ¡A¦Ó¬O¥u¾Ç·|"¤ñ¤j"¡A«o¨S¾Ç·|"¤ñ¤p"~¤ß¸Ì«Ü¤£¬O´þ¨ý«Ü¤£½ñ¹ê^^"
´N¦p°Ï°ì°}¦C¤ñ¤j¤ñ¤pªº¤½¦¡¡A¦]¸g¹LMª©¥Dªº­@¤ß±Ð¾É¡A¤p§Ì¤~¾Ç·|¤F¡C
ÁÂÁ±z­Ì¤G¦ì^^

TOP

¦^´_ 7# ML089
ª©¥D:
ÁÂÁ±zªº¦A¦¸½ç±Ð!ÁÂÁ±z^^

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD