½Ð°ª¤â«üÂI¤@¤U¡A¦p¦ó°µ¥X°ÊºAªº¦æ¨Æ¾ä¤ÎÂùÀ»¿ï¾Ü¿é¤Jªº¥\¯à¡H
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 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¬°¤°»ò... |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ 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.... |
|
|
|
|
|
|
- ©«¤l
- 79
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 123
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- x64
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2013-10-24
- ³Ì«áµn¿ý
- 2024-3-28
|
¦^´_ 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¬¡¡^
|
|
|
|
|