[µo°Ý] ¿é¤J¤é´Á´M§ä¬Û¹ïÀ³ªº¦C¸¹

cw3076

Dear ¤j¤j,
¦pªþ¥ó§@ªíA ¿é¤J¤é´Á±ý¨ú±oB¤u§@ªí¬Û¹ïÀ³ªº¦C¸¹,
°µ¥X¨Ó³£©Ç©Çªº, ·Ð½Ð¤j¤j¸Ñµª


[attach]1744[/attach]

cw3076

·PÁ¦U¦ìª©¤jªº«ü±Ð, ¸ÑªkÁÙ¬O¯u¦h¤X,

Hsieh ª©¤j's °}¦C¤½¦¡
{=MATCH($B3,DATEVALUE(TEXT(OFFSET(B!$E$1,,,COUNTA(B!$E:$E),),"yyyy/m/d")),1)}
§â0 ­×§ï¬°1 ¦ü¥G´N¥i¥H§ä¨ì²Å¦X¤é´Áªº³Ì«á¤@­Ó¦C¼Æ. (Sorry, ¸Ô²Óªº¥Îªk§ÚÁÙ¤£¬O«Ü²M·¡)

ªþ¥ó¬°¦U¦ì¤j¤j¤½¦¡ªºsummary, ¦³¿³½ìªº¥i¥H¬Ý¬Ý


0709 Summary for find row.zip (8.33 KB)

¤U¸ü¦¸¼Æ: 9

2010-7-9 13:45

gong

c3
{=MATCH($B3,INT(B!$E$1:$E$418),0)}
³Ì¤j¤é´Á
=MATCH($B3+0.9999,B!$E$1:$E$418,1)

asimov

¦^ÂÐ1¼Ó
C3
{=MATCH(TEXT(B3,"yyyymd"),TEXT(B!E$2:E$1000,"yyyymd"),)+1}

¦^ÂÐ3¼Ó
¬O³o·N«ä¶Ü ?
D3 ...
zz5151353 µoªí©ó 2010-7-8 08:54

­Ézz5151353ª©¥D¤½¦¡¤@¥Î
¤é´Á³Ì¤p¦C¸¹
{=MATCH(INT(B3),INT(B!$E$1:$E$500),0)}

¤é´Á³Ì¤j¦C¸¹
{=MATCH(INT(B3),INT(B!$E$1:$E$500),1)}

zz5151353

¦^ÂÐ1¼Ó
C3
{=MATCH(TEXT(B3,"yyyymd"),TEXT(B!E$2:E$1000,"yyyymd"),)+1}

¦^ÂÐ3¼Ó
¬O³o·N«ä¶Ü ?
D3

=LOOKUP(1,0/(TEXT(B3,"yyyymd")=TEXT(B!E$2:E$1000,"yyyymd")),ROW($2:$1000))

OR

{=MATCH(1,0/(TEXT(B3,"yyyymd")=TEXT(B!E$2:E$1000,"yyyymd")))+1}

cw3076

Dear Hsieh ª©¤j,
  Very Thanks for quickly & prompt reply.
  §Ú·|¦A¬ã¨s¤@¤U¤½¦¡, ¥t§Ú·Q¨ú±o³]©w¤é´Áªº³Ì«á¤@¦C¤½¦¡¸Ó¦p¦ó­×§ï©O?

Hsieh

C3°}¦C¤½¦¡
{=MATCH($B3,DATEVALUE(TEXT(OFFSET(B!$E$1,,,COUNTA(B!$E:$E),),"yyyy/m/d")),0)}