- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-22 17:15 ½s¿è
¦^´_ 3# shan0948
1¡B¥i¦Ò¼{ª½±µÅܧó°}¦C¤½¦¡¤¤¬õ¦â³¡¤Àªº¦~¤ë¤À¤Î¤é´Á
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2,0)
©Î
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=DATE(2014,8,1),ROW($A$3:$A$8),FALSE),1)-2)
2¡B©ÎªÌ¦Ò¼{«ü©w¬Y¤@¯S©wÀx¦s®æ¬°¡u¤é´Á¡v¤ñ¹ï¼Ðªº¡A¦pÀx¦s®æH6 (©ó¦¹¿é¤J2014/8/1)¡A«h°}¦C¤½¦¡×§ï¬°
Àx¦s®æH8=OFFSET(E$2,LARGE(IF($A$3:$A$8=$H$6,ROW($A$3:$A$8),FALSE),1)-2,0)
©Î
Àx¦s®æH8=INDEX(E$3:E$8,LARGE(IF($A$3:$A$8=$H$6,ROW($A$3:$A$8),FALSE),1)-2)
½Ð°Ñ¦Ò¡I
µù¡G°}¦C¤½¦¡½Ð¥HCtrl+Shift+Enter¿é¤J |
|