- ©«¤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-7-8 16:15 ½s¿è
¦^´_ 4# ffff56666
1¡Bfor Excel 2007: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IFERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))),"")
µù¡G±zªº³nÅ骩¥»¤£¬O¼Ð¥ÜOffice 2007¡H
2¡Bfor Excel 2003: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IF(ISERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1)))),"",DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))))
Àx¦s®æB43®æ¦¡¤§¡u¼ÆÈ¡v½Ð³]¬°¡u¤é´Á¡v¡A¦V¥k¡B¦V¤U½Æ»s¡C
½Ð°Ñ¦Ò¡I |
|