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

³]©w¤@±ø¥ó§ìÁ`ªí¸ê®Æ

³]©w¤@±ø¥ó§ìÁ`ªí¸ê®Æ

ÀÉ®×¥]§t¨â­Ó¤u§@ªí¡G³øªí¦C¦L¤ÎÁ`ªí
1.¦b³øªí¦C¦L¤u§@ªíB2Àx¦s®æ¿é¤J¾P±b¤é¡A«hC7¡GF11¦Û°Ê±a¤JÁ`ªí¤u§@ªí©Ò¹ïÀ³ªºÄæ¦ì¡D
¨Ò¦p¡G¾P±b¤é¬°2013/8/1«h¦Û°Ê±a¤JÁ`ªí¤u§@ªíB3:U3ªº¸ê®Æ

¥t¥~¡A­Y±a¥X¨Óªº¬OªÅ­È¡A³]©w¦¨¦¹²Å¸¹ -

PS.¶À¦â°Ï°ì¬°³]©w¤½¦¡°Ï

2.³øªí¦C¦L¤u§@ªí¤§A3Àx¦s®æ¤§¤ºªº¤@¬q¤å¦r¡A¨ä¤¤¡G¾P±b¤é¬O§_¥i¥H©MB2Àx¦s®æ³sµ²

102¦~«×«D°O¤í.zip (11.2 KB)

joyce

c7=INDEX(Á`ªí!$A$1:$Z$99,MATCH($B$1,Á`ªí!$A$1:$A$99,),MATCH($B7,Á`ªí!$A$1:$U$1,)-1+MATCH(C$6,Á`ªí!$B$2:$E$2,))
e7  µo²¼ª÷ÃB¡]§tµ|¡^ªº®æ¦¡»Ý»PÁ`ªí¬Û¦P,F7¦P²z

TOP

¦^´_ 2# ANGELA


    ÁÂÁÂANGELA

½Ð°Ý¬°¦ó­n¨â¤u§@ªíªº®æ¦¡¬Û¦P¤~§ìªº¨ì­È©O?

¥t¥~¡A­Y±a¥X¨Óªº¬OªÅ­È¡A¦p¦ó³]©w¦¨¦¹²Å¸¹ -

¥t¤@°ÝÃD¡G
³øªí¦C¦L¤u§@ªí¤§A3Àx¦s®æ¤§¤ºªº¤@¬q¤å¦r¡A¨ä¤¤¡G¾P±b¤é¬O§_¥i¥H©MB2Àx¦s®æ³sµ²
joyce

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2013-8-15 15:03 ½s¿è

¦]Á`ªíF6¦h¤F¤À¦æ²Å¸¹,²Î¤@®æ¦¡¬O¸û¦nªº²ßºD.
c7=INDEX(Á`ªí!$A$1:$Z$99,MATCH($B$1,Á`ªí!$A$1:$A$99,),MATCH($B7,Á`ªí!$A$1:$U$1,)-1+MATCH(LEFT(C$6,3)&"*",Á`ªí!$B$2:$E$2,))
Àx¦s®æ®æ¦¡§ï¦¨·|­p±M¥Î
="¥x¥_¤À¤½¥q¡@¾P±b¤é¡G"&TEXT(B1,"yyyy/m/d")&" «D°O¤í¥U³ø¼Æ"

TOP

¦^´_ 4# ANGELA


    «D±`·PÁÂANGELA
±z´£¨ì§ï¦¨·|­p±M¥Î,§Ú¬O¿ï¥ÎµL,¥i¬O³øªí½s¸¹,·|µø¬°ª÷¿ú,¥H¤d¤À¦ì³rÂI

¤£¦n·N«ä,¤@ª½´£°Ý°ÝÃD
joyce

TOP

¦^´_ 5# leiru


    ¦pªG¤@©w­n¥h±¼¤d¤À¸¹¨º´N¥Î¦b³øªí½s¸¹Äæ¦ì¥ÎTEXT()¨ä¥¦Äæ¦ì¤£¯à¥Î,¦]TEXT()·|§â¼Æ¦r§ï¦¨¤å¦r,¤£¯à­pºâ.

    =TEXT(INDEX(Á`ªí!$A$1:$Z$99,MATCH($B$1,Á`ªí!$A$1:$A$99,),MATCH($B7,Á`ªí!$A$1:$U$1,)-1+MATCH(LEFT(C$6,3)&"*",Á`ªí!$B$2:$E$2,)),"0;0;-")

TOP

³øªí¦C¦L¤u§@ªí¤ºC10:F10¡A¬O§ìÁ`ªí¤u§@ªíNÄæ¦ÜQÄæ
³øªí¦C¦L¤u§@ªí¤ºC11:F11¡A¬O§ìÁ`ªí¤u§@ªíRÄæ¦ÜUÄæ
°ÝÃD¡G
³øªí¦C¦L¤u§@ªí¤ºC10:F10¡A¥u­nÅã¥ÜC10:E10ªº­È¡A¤£Åã¥ÜF10ªº­È
³øªí¦C¦L¤u§@ªí¤ºC11:F11¡A¥u­nÅã¥ÜC11¡BD11¡BF11ªº­È¡A¤£Åã¥ÜE11ªº­È

102¦~«×«D°O¤í.zip (11.51 KB)

joyce

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD