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

[¨D±Ð]Excel¨C¤ë¤é¤l¶¶§ÇÅã¥Ü°ÝÃD,·PÁÂ

[¨D±Ð]Excel¨C¤ë¤é¤l¶¶§ÇÅã¥Ü°ÝÃD,·PÁÂ

¥»©«³Ì«á¥Ñ DanteSiu ©ó 2015-10-27 13:40 ½s¿è

05OCT-11OCT
12OCT-18OCT
19OCT-25OCT
26OCT-01NOV
02NOV-08NOV
09NOV-15NOV
16NOV-22NOV
23NOV-29NOV
30NOV-06DEC

¦p¦ó¥O³o¨Ç¤é¤l¶¶§Ç¾î¦VÅã¥Ü¥X¨Ó

¤@        ¤G        ¤T        ¥|        ¤­        ¤»        ¤é
02        03        04        05        06        07        08

¦p¤W­±©ÒÅã¥Ü,§â02,03,04,05,06,07,08¥ÎFORMULAS
¦]¬°³o­Ó¬O§óªí,¥H¤Wªº¼Æ¦r³£¬O¤H¤â¥´ªº,¦]¬°¥L¬O¨C¤@­Ó¬P´Á¥hÅã¥Ü¥X¨Óªº,¤£¥i¯à¬O¥u¥X²{¤@­Ó¤ëªº¤é¤l,°ò¥»¤W³£¬O¥X²{¨â­Ó¤ë¥÷,¦Ó¥B¬O¦³¤À4WEEK©M5WEEK
¥ÎIF¤]¤£¯à·Ç½T¦a§â¨C­Ó¤ë¥÷ªº¼Æ¦rÅã¥Ü¥X¾¤

¤ñ¦p:OCT¦³31¤é,NOV¦³30¤é,¦ý§Ú§ä¤£¨ì¤èªk¥OOCT31¤U¤@­ÓÅã¥Ü¥X¨Ó¬ONOV01³o¼Ë

¨D°ª¤â±Ð:'( :'( ·PÁÂ:'(

TOP

yen956 µoªí©ó 2015-10-27 13:49



    §Úªº­­ÅvµLªk¶}rarÀÉ,¥i§_²©ö»¡©ú¤@¤U,ÁÂÁÂ

TOP

http://blog.xuite.net/hcm19522/twblog/242927757
°Ñ¦Ò

TOP

http://blog.xuite.net/hcm19522/twblog/352538053

TOP

http://blog.xuite.net/hcm19522/twblog/352566544

TOP

http://blog.xuite.net/hcm19522/twblog/352538053
hcm19522 µoªí©ó 2015-10-27 15:58



    ·PÁ¤j¤j:D

    §Ú·Q°Ý¬°¤°»ò­n¥[ COLUMN(A1)-1
    «D±`·PÁ§A:D

TOP

LEFT($A2,5)¬°²Ä¤@¤Ñ ,COLUMN(A1)-1=0 ,¥k²¾¤@®æ-->2-1¬°²Ä¤@¤Ñ+1 ,¦A¥k²¾¤@®æ¬°3-1-->²Ä¤@¤Ñ+2 ....¥H¦¹Ãþ±À
http://blog.xuite.net/hcm19522/twblog/352538053  ¦³¥[µù

TOP

LEFT($A2,5)¬°²Ä¤@¤Ñ ,COLUMN(A1)-1=0 ,¥k²¾¤@®æ-->2-1¬°²Ä¤@¤Ñ+1 ,¦A¥k²¾¤@®æ¬°3-1-->²Ä¤@¤Ñ+2 ....¥H¦¹Ãþ ...
hcm19522 µoªí©ó 2015-10-28 13:56



    ·PÁ¤j¤j:D

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD