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

5­Ó¤H ¤À°t 4­Ó¤u§@ ±Æ¦C²Õ¦X

5­Ó¤H ¤À°t 4­Ó¤u§@ ±Æ¦C²Õ¦X

test.zip (4.18 KB) ¦pÃD ½Ð±Ð¦U¦ì«e½ú ÁÂÁ !

¥»©«³Ì«á¥Ñ Eugene ©ó 2011-6-21 06:04 ½s¿è

¦w³á¡I
§Ú¤]¬O¤p¾Ç¥Í¡A©Ò¥H¤£¯à¤U¸ü±zªºÀɮסC©Ò¥H¦Û¤v°µ¤F¤@­Ó¡A±z°Ñ¦Ò¬Ý¬Ý¡I
P.S. ¤u§@ªº§Ç¸¹¥²¶·¬O¨Ì§Ç¬y¤ô¸¹

¤£¹L¡A¥t´£­Ó°ÝÃD¡G
³o­Ó¨Ò¤l³Ì¤j¥u¦³ 5 ­Ó¤u§@ªº´`Àô¡A¥Î KEYIN °Å¶K¤£¬O«Ü§Ö¶Ü¡H³o¯à¥Î¦b­þ¸Ì°Ú¡H

Book2.rar (7.76 KB)

Book2.rar

TOP



B3=INDEX($B$1:$F$1,1,IF(($A3+MATCH($B$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($B$2,$B$2:$E$2,0)-1)))
B4=INDEX($B$1:$F$1,1,IF(($A3+MATCH($C$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($C$2,$B$2:$E$2,0)-1)))
B5=INDEX($B$1:$F$1,1,IF(($A3+MATCH($D$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($D$2,$B$2:$E$2,0)-1)))
B6=INDEX($B$1:$F$1,1,IF(($A3+MATCH($E$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($E$2,$B$2:$E$2,0)-1)))

¿ï¨ú B3 ~ B6 ©¹¤U½Æ»s§Y¥i¡C

TOP

5¿ï4ªº±¡ªp¤U¥u¦³5ºØ²Õ¦X
1234¡A1235¡A1245¡A1345¡A2345
À³¸Ó¨S¥²­n¤j¶O©P³¹
­Y²Õ¦X¼Æ¦h®É¤~¦³¥²­n¼gµ{¦¡¡C

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD