- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 14
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-6
|
§Ú»¡ªº¤£°÷²M·¡,À³¸Ó¥H¤U¦p¦¹Ãþ±À:
¤é´Á ¾û ¥X¶Ô®É¶¡
13/1 ...
hkyan µoªí©ó 2013-11-18 16:32
¨º´N¦A¥[¤@¦æ°µ§PÂ_Åo.
¥H 3 # ¬°¨Ò°µ½Õ¾ã, °²³] :
AÄæ ¤é´Á A1=¤é´Á A2==INDIRECT(CONCATENATE("f",E2),1) (¥H¤U©ì¦²½Æ»s)
BÄæ ¤W¯Zû¤u B1=¾û B2==INDIRECT(CONCATENATE("M",MOD(ROW(B2)-2,11)+2),1) (¥H¤U©ì¦²½Æ»s)
CÄæ C1=¥X¶Ô®É¶¡
DÄæ ªÅ¤@Äæ¥H»Ppºâ°Ï°µ°Ï¹j
EÄæ ¤é´Á¯Á¤ÞÈ E1=1 E2==IF(B2=$M$2,E1+1,E1) (¥H¤U©ì¦²½Æ»s) <= ¥[³o¤@Äæ°µ¨C¤@½ü¤é´Á²§°Êªº¨Ì¾Ú.
FÄæ F1=¹ê»Ú¤W¯Z¤é F2==IF(ISERROR(VLOOKUP(ROW(A2),$H$2:$I$40,2,0)),"",VLOOKUP(ROW(A2),$H$2:$I$40,2,0)) (¥H¤U©ì¦²½Æ»s)
GÄæ °²¤épºâ²Ä1¬q G1=1 G2==IF(G1>100,IF(J2<>"°²¤é",G1-100+1,G1-100),IF(J2<>"°²¤é",G1+1,G1+100)) (¥H¤U©ì¦²½Æ»s)
HÄæ °²¤épºâ²Ä2¬q H1=1 H2==IF(G2<100,G2,"") (¥H¤U©ì¦²½Æ»s)
IÄæ ©Ò¦³¤é´Á I1=2013/10/31(¤W¯Zº¤éªº«e¤@¤é) I2==I1+CHOOSE(WEEKDAY(I1+1,2),1,1,1,1,1,3,2) (¥H¤U©ì¦²½Æ»s)
JÄæ J1=°²¤éµù°O J2==IF(ISERROR(MATCH(F2,$I$2:$I$15,0)),"","°²¤é") (¥H¤U©ì¦²½Æ»s)
KÄæ ªÅ¤@Äæ¥H»P¸ê®Æ°Ï°µ°Ï¹j
LÄæ °²¤é¤é´Á¦Cªí©ñ¦b L2 ¤Î¨ä¤§¤UªºÀx¦s®æ
MÄæ û¤u©m¦W ©ñ¦b M2 ~ M12
«h A¡BB¡BC Äæ´N¬O§Anªº¸ê®Æ.
¤U¤èªþÀɤ¤°²¤éªº¤é´Á¬OÀH·N½sªº, ½Ð¨Ì¹êªp¦Û¦æקï¿é¤J
¥X¶Ôªí-a2.zip (6.34 KB)
|
|