ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¤@¤U

[µo°Ý] ½Ð°Ý¤@¤U

½Ð°Ý¦U¦ì¤j¤j»P«e½ú

­n«ç»ò§ì¥X¨C¦~ªº²Ä¤@¤Ñ¡A¦ý¬O¤£¬O§ì¨ú1¤ë1¤é¡A

¦Ó¬O§ì¨ú¥Ø«eªº¸ê®Æ¬O·í¦~ªº²Ä¤@¤Ñ

¨Ò¦p¡G¦b2000¦~¥X²{ªº²Ä¤@µ§¸ê®Æ¬O 2000/1/4

¡@¡@¡@¦b2001¦~¥X²{ªº²Ä¤@µ§¸ê®Æ¬O 2001/1/3

¡@¡@¡@¦b2002¦~¥X²{ªº²Ä¤@µ§¸ê®Æ¬O 2002/1/1

¦^´_ 1# EGBT

§ì2000¦~³Ì¦­¤é´Á
{=MIN(IF(YEAR(A$1:A$999)=2000,A$1:A$999))}
¥ÎCTRL+SHIFT+ENTER¤TÁä»ô«ö¤è¦¡¿é¤J¤½¦¡

¥i¥H±N 2000 §ï¬°Àx¦s®æ §@¬°ÅÜ°Ê
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¢Ñ¢°¡D¦~«×¡G2000¡@¡]¥i¤U©Ô¤£¦P¦~«×¡^
¢Ò¢°¡G
=IF(FREQUENCY(A:A,--(C1-{0,1}&"/12/31")),SMALL(A:A,COUNTIF(A:A,"<"&C1&"/1/1")+1),"")

TOP

«Ü·PÁ¦U¦ì¤j¤jªº¦^µª

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD