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

½Ð°ª¤â«üÂI¤@¤U¡A¦p¦ó°µ¥X°ÊºAªº¦æ¨Æ¾ä¤ÎÂùÀ»¿ï¾Ü¿é¤Jªº¥\¯à¡H

¦^´_ 10# eigen
§Ú¨ì©w¸q¦WºÙ¤¤§â
month_first_day   =OFFSET(¤ë¾ä!$B$2,QUOTIENT(ROW()-4,9)*9,QUOTIENT(COLUMN()-2,8)*8,,)
ªº¤ë¾ä!§R±¼¡AÁöµM·|¦Û¤v´_­ì¡A¦ý¬O­È´N¥¿½T¤F....

§Ú¤]¤£ª¾¹D¬°¤°»ò...

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2013-12-17 00:09 ½s¿è

¦^´_ 10# eigen
§â­¼ªº¯Â¼Æ¦r´«¨ì«e­±¬Ý¬Ý¡A
month_first_day   =OFFSET(¤ë¾ä!$B$2,9*QUOTIENT(ROW()-4,9),8*QUOTIENT(COLUMN()-2,8),,)

¤]¥i¯à¬Oª©¥»¤£¦PÃö«Y¡A©Ò¥H¬Ý¨ìµ²ªG¤£¦P§a....

TOP

¦^´_ 12# stillfish00

³Ì«áªº¸Ñªk¡G =OFFSET($B$2,int((ROW()-4)/9)*9,int((COLUMN()-2)/8)*8,,)

¥Î int(a/b) ¨ú¥N quotient(a,b)

¥X°ÝÃDªº­ì¦]¦]¸Ó¬O excel 2003 quotient ÄÝ©ó¼W¯q¶°¡A«Dexcel ¥»¥Íªºfunction.

¥X¿ùªº­ì¦]À³¸Ó¬O  quotient ( row()-4,9)  row()-4 ºâ¥X¨Óªº­È¤£¬O¼Æ¦r¡Ais nonnumeric .

±Nquotient ¥Î int(a/b)¨ú¥N¤§«á´N¥i¥H³Q ¦WºÙ©w¸q¨ú¥N¡C

´«¦¨§ó°ªª©¥»À³¸Ó´N¤£·|¦³³o¼Ëªº©Ç²{¶H¡C
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD