- 帖子
- 14
- 主題
- 0
- 精華
- 0
- 積分
- 53
- 點名
- 0
- 作業系統
- XP, Vista & Window7
- 軟體版本
- Office 2003 & 2007
- 閱讀權限
- 20
- 性別
- 男
- 註冊時間
- 2011-6-16
- 最後登錄
- 2023-5-30
|
3#
發表於 2011-6-21 06:02
| 只看該作者
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 往下複製即可。 |
|
發表於 2011-6-21 08:00
| 
