- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-1 10:49 ½s¿è
¦^´_ 1# maiko
¥H½d¨ÒÀÉ ABook1.xlsx¸ê®ÆÄæ¦ì°t¸m¸Ñ
1¡B©w¸q¦WºÙ¡uDate¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J =YEAR(OFFSET(Sheet1!$K$2,,,COUNTA(Sheet1!$K:$K)-1))¡C
2¡BÀx¦s®æS1¿é¤JÄæ¦ì¦WYear¡AÀx¦s®æS2¿é¤J°}¦C¤½¦¡ =IFERROR(INDEX(Date,MATCH(0,COUNTIF($S$1:S1,Date),0)),"")¡A¦V¤U½Æ»s¤½¦¡¡C
3¡B©w¸q¦WºÙ¡uYear¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(Sheet1!$S$2,,,COUNT(Sheet1!$S:$S))¡A¦A©óÀx¦s®æA2»s§@²M³æ¡A²M³æ¡u¨Ó·½¡v¿é¤J =Year¡C
½Ð°Ñ¦Ò¡I |
|