- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-1-23 10:37 ½s¿è
1/1¬O2*300¡B1/2¬O3*300¡B1/3¬O4*300ªº½d³ò
¬O«ü1/1®É°ÊºA½d³òªº¤j¤p¬O2Äæ*300¦C¡B1/2¬°3Äæ*300¦C¡B1/3¬°4Äæ*300¦C
©w¸q¦WºÙªº¤½¦¡¦p¤U:
OFFSET(¶q²£ºôª©!$A$1,MATCH(Á`ªí!D$3,¶q²£!$A:$A,0),3,MATCH(Á`ªí!E$3,¶q²£!$A:$A,0)-MATCH(Á`ªí!D$3,¶q²£ºôª©!$A:$A,0)-12,DAY(Á`ªí!B47+1))
offsetªº¼e§Ú¨Ã«D©wÈ
ÁÂÁÂHsiehª©¥Dªº¦^µª
§Ú·|¬ã¨s¬Ý¬Ý¬O¤£¬O¥i¥H¦¨¥\®M¨ì§Ú»Ýnªº¦a¤è
¤å¥ó¬°¤½¥q¤º³¡ªºªF¦è¡A¤£¤è«Kª½±µ¤W¶Ç
¥B§Ú§Æ±æ¾Ç¨ì¤èªk¦Ó¤£¬O¥u¬O±o¨ì¤j®a¨ó§U(°ÝÃD¸Ñ¨M¤F·|¦³´k©Ê¡A¤Ï¦Ó¨S¾Ç¨ìªF¦è) |
|