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

½Ð°ÝÃĥάƻò¨ç¼Æ¨ÓÂà´«¤¤¤å¦r¦¨¼Æ­È,¨Ò¦p:¦~ÄÖ¥|¤Q·³¤S56¤Ñ

½Ð°ÝÃĥάƻò¨ç¼Æ¨ÓÂà´«¤¤¤å¦r¦¨¼Æ­È,¨Ò¦p:¦~ÄÖ¥|¤Q·³¤S56¤Ñ

½Ð°ÝÃĥάƻò¨ç¼Æ¨ÓÂà´«¤¤¤å¦r¦¨¼Æ­È,¨Ò¦p:¦~ÄÖ¥|¤Q·³¤S56¤Ñ ÁÂÁÂ

¦~ÄÖ¥|¤Q·³¤S56¤Ñ
­nÂର
¦~ÄÖ40·³¤S56¤Ñ ?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

À³¸Ó»¡¥H¼Æ¦rÅã¥Ü40.15·³¡AÁÂÁÂ

TOP

A1  ¦~ÄÖ¥|¤Q·³¤S56¤Ñ

B1 =LOOKUP(1,0/FIND(NUMBERSTRING(ROW($1:$120),1),A1),ROW($1:$120))+LOOKUP(1,0/FIND(TEXT(ROW($1:$366)-1,"0¤Ñ;;"),A1),ROW($1:$366)-1)/365
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«z,±z¯uªº«Ü±j³á
ÁÂÁ±zªº«ü¾É ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-9-2 15:54 ½s¿è

­Y¬O¡G¦~ÄÖ¤Q¤E·³¤S33¤Ñ¡A"¤@¤Q¤E"¶·Âà¤Æ¡A
¸É¥R¤@¤U¡G
=LOOKUP(1,0/FIND(SUBSTITUTE(NUMBERSTRING(ROW($1: $120),1),"¤@¤Q","¤Q"),A1),ROW($1: $120))+LOOKUP(1,0/FIND(TEXT(ROW($1: $366)-1,"0¤Ñ;;"),A1),ROW($1: $366)-1)/365

¬°¦ó¶K¤½¦¡®É¡A¦Ñ¬OÅܦ¨ªí±¡²Å¸¹¡A«D±o¥[¤@ªÅ®æ¡ã¡ã
¡@¡@

TOP

¦^´_ 6# ­ã´£³¡ªL


   
µo©«¿ï¶µ - ¸T¥Îªí±¡¡A¥ý¨ú®ø¦b¤Ä¿ï¤@¦¸¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ½å½ú­Ìªº¼ö¤ß«ü¾É ÁÂÁÂ.

TOP

http://blog.xuite.net/hcm19522/twblog/357126809
«e¥b¬q°Ñ¦Ò "­ã¤j"
=ROUND(LOOKUP(1,0/FIND(SUBSTITUTE(NUMBERSTRING(ROW($1:$99),1),"¤@¤Q","¤Q"),B2),ROW($1:$99))+MAX(IFERROR(MID(B2,ROW($1:$19),COLUMN(A:T))/365,)),2)&"·³"

TOP

{=ROUND(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"¤@¤Q","¤Q"),B2),ROW($1:$99))+MAX(IFERROR(MID(B2,ROW($1:$19),COLUMN(A:T))/365,)),2)&"·³"

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD