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

[µo°Ý] Excel¤ñ¹ï¤é´Á¤Î±ø¥ó«á±a¥X¼Æ¦r¤½¦¡?

[µo°Ý] Excel¤ñ¹ï¤é´Á¤Î±ø¥ó«á±a¥X¼Æ¦r¤½¦¡?

¥»©«³Ì«á¥Ñ msmplay ©ó 2016-3-28 22:22 ½s¿è

·Q½Ð±Ð¤@¤U¤j®v­Ì~~~~~

1.PNG
2016-3-28 22:21
2.PNG
2016-3-28 22:21


°ÝÃD¡G
§Æ±æ¦Û°Ê¤ñ¹ïB1»P¡u¯Zªí¡v¬Û¦P¤é´Á·í¤Ñ¡A­þ¨Ç¤H¦³±Æ¡u¯S¡v¥ð
¨Ã©ó¤ñ¹ï«á©óB4:B22¦Û°Ê±a¥X®É¼Æ¡u8¡v

¨Ò¦p:
B1=3/25¡A¡u¯Zªí¡v²Ä¤T¦C¤é´Á25¬°AD3¡A¬G¤ñ¹ïAD3Äæ«á¡uQ§g¡v»P¡uS§g¡v¦U¦³¡u¯S¡v
¬GB20»PB22¦Û°Ê±a¥X¼Æ¦r8

¥H¤W¨D¸Ñ~~~~~~«D±`·PÁÂ!!!!

´ú¸Õ.rar (11.68 KB)

¦^´_ 1# msmplay

©ó"²Î­p¬¡­¶"¤u§@ªíªºB4Àx¦s®æ¿é¤J=IF(OFFSET(¯Zªí!C5,0,DAY(²Î­p¬¡­¶!$B$1)+2)="¯S",8,"")
¤U©Ô½Æ»s§Y¥i¡A¤£¹L¬°·j´M¤è«K¡A«Øij±N"¯Zªí"¤u§@ªíªºAB21Àx¦s®æ§ï¦¨"¯S"¥H¤è«K¬d¸ß~

TOP

¦^´_ 1# msmplay


    B4=(VLOOKUP(²Î­p¬¡­¶!$A4,¯Zªí!$C$5:$AJ$23,DAY(²Î­p¬¡­¶!$B$1)+3,0)="¯S")*8
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ msmplay ©ó 2016-3-29 12:41 ½s¿è

¦^´_ 2# tku0216
¦^´_ 3# Hsieh
*^O^*ÁÂÁ¤j®v¸Ñ´b~~~~

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD