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

hanse

¤U¸ü (4.55 KB)

2011-6-20 14:04

test.zip (4.18 KB)

¤U¸ü¦¸¼Æ: 7

2011-6-20 14:06

¦pÃD ½Ð±Ð¦U¦ì«e½ú ÁÂÁ !

Eugene

¦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

Eugene

¤U¸ü (24.72 KB)

2011-6-21 05:56

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

oobird

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