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

¥ë­¹¶O³æ¤é­pºâ°ÝÃD

¥ë­¹¶O³æ¤é­pºâ°ÝÃD

¦U¦ì¥ý¶i¦n¡A¤p§Ì¦³¤@¥ë­¹¶O³øªí­pºâªº°ÝÃD­n³Â·Ð¨ó§U¤½¦¡³]©w¡A¦]°ÝÃD»¡©ú¸û¦h¤w¦bªþÀɤ¤»¡©ú¡AÁÂÁ¡A·P®¦¡I

¥ë­¹³øªí.rar (12.97 KB)

¦W¥U¤¤ªº¤é´Á¤Ö±¼¦~¤ë¥÷¸ê°T¡AµLªk§P§O¬O31¤Ñ©Î30¤Ñ©Î29¤é©Î28¤é
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    ÁÂÁÂMLª©¥Dªº«ü¾É¡AªþÀɯʤ֦~¤ë¸ê°T¡A²{¤w§ó·sªþÀɸê®Æ¡A·Ð½ÐMLª©¥D«ü¥¿¡A·P®¦¡I ¥ë­¹³øªí.rar (12.96 KB)

TOP

¦^´_ 3# shan0948

J4¤½¦¡
=SUM(OFFSET(¥ë­¹¶O¼Ð·Ç!$A$3,F4,MATCH($O$2&"¤é",¥ë­¹¶O¼Ð·Ç!$2:$2,),H4-F4+1))
¤½¦¡©¹¤U½Æ»s

O2 ¶ñ¤J 31 (¸Ó¤ë¤Ñ¼Æ)

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    MLª©¥D¦n¡A¨ç¼Æ¤½¦¡¸g´ú¸Õ«á¥i¥H¨Ï¥Î¼Æ­È¥¿½T¡A¹ï¤p§Ì¤u§@§U¯q¬Æ¤j¡A·P®¦ÁÂÁ¡I

TOP

·Q½Ð±Ð¤@¤U.. ­YµM¤£·Q­pºâ¬P´Á¤é¤Î¤½²³°²´Á.... ¦Ó¤½²³°²´Á¥i¥H¦b¥t¤@¤u§@ªí¦C¥X..
³o¼Ëªº¸Ü¤S¥i¥H«ç­pºâ¥X¥ë­¹¤Ñ¼Æ©O...

¥ýÁÂÁ¦^µª!!

TOP

¦^´_ 6# jomeow


    §A¦n¡A§Aªº°ÝÃDªº½T¬O¤@­Ó¤è¦V¡A¦³ªº¦a¤è©Î¾÷Ãö°²¤é©Î¤£¤W¯Z«hµL¥ë­¹¶O¡A§Úªº±¡ªp¬O¤£ºÞ°²¤é365¤Ñ³£¦³¥ë­¹¶O¡A¦p¦³°²¤é¤£­pºâ¨º´N¤ñ¸ûÁcÂø¤F¡I

TOP

¦^´_ 7# shan0948


    ©Ò¥H´N·Qª¾¹DÀ³¸Ó«ç¼Ë³B²z©O~~

TOP

¦^´_ 8# jomeow


    ¥Ø«e¦]µL°²¤é³o¤è­±°ÝÃD¡A±z©Ò´£¥Xªººc·Q¼È®ÉÁÙ¨S¦³·§©À¡A¤£¦n·N«ä¡I

TOP

¦^´_  jomeow


    ¥Ø«e¦]µL°²¤é³o¤è­±°ÝÃD¡A±z©Ò´£¥Xªººc·Q¼È®ÉÁÙ¨S¦³·§©À¡A¤£¦n·N«ä¡I
shan0948 µoªí©ó 2014-12-17 19:59



ÁÂÁ±z..  §Ú¤]¨S¦³¹ê½èªº°ÝÃD¨Ó°Ý©O.. ^^!

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD