¦p¦ó±N¤£³sÄò¤é´Á¸Éº¡

paul3063

¤wª¾AÄæ³£¬O¤é´Á¡A¨Ò¦p106/07/26¡A106/06/30¡A
¦p¦ó±N¤£³sÄò¤é´Á¸Éº¡¡A
¨Ã±N¸Éº¡ªº¤é´Á»ù®æ¥Î«e¤@¤Ñªº»ù®æ´À¥N


Download Page Link

https://www.sendspace.com/file/42vab4

hcm19522

http://blog.xuite.net/hcm19522/twblog/550915735

joblyc017

¦^´_ 1# paul3063


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/KhGkDA

¤U¸ü (344.06 KB)

2017-12-9 10:49

hcm19522

http://blog.xuite.net/hcm19522/twblog/550942416

paul3063

¦^´_ 3# joblyc017


ÁÂÁ±z

D2="106/"&TEXT(--("2017/07/27")-ROW(A1),"mm/dd")
E2=OFFSET($B$20,-SUMPRODUCT(--(D2>=$A$2:$A$19)),)

paul3063

¦^´_ 4# hcm19522


´ú¸Õµ²ªGµo²{¡A¯Ê¤Ö¤é´Áªº»ù®æÀ³¸Ó¬O­n¸ò«e¤@¤Ñªº¤é´Á»ù®æ¤@¼Ë¡A¥i¬O±zªº¦n¹³¬O¸ò«á­±¤@¤Ñªº¤é´Á¤@¼Ë¤F¡A¤£ª¾¹D¨ºÃä¥X¤F°ÝÃD
106/07/24        28.40
106/07/23        28.40
106/07/22        28.40
106/07/21        28.45
-----------------
106/07/10        28.25
106/07/09        28.25
106/07/08        28.25
106/7/7        28.35

hcm19522

¦^´_ 6# paul3063


    L2:L19{=IF(K2="","",OFFSET(I$1,MATCH(,0/(K2>=H$2:H$9),),))

E2:E19{=IF(D2="","",OFFSET(B$1,MATCH(,0/(("R"&D2)-("R"&A$2:A$9)>=0),),))

Hsieh

¦^´_ 1# paul3063


    D2=TEXT(--"2017/7/26"+2-ROW(),"e/mm/dd")
E2°}¦C¤½¦¡=INDEX(B:B,MIN(IF($A$2:$A$62<=D2,ROW($2:$62),"")),)

paul3063

¦^´_ 7# hcm19522


    hcm19522¤j¡A¥i¥H¤F¡AÁÂÁ±z¡C

paul3063

¦^´_ 8# Hsieh


    Hsieh¤j¡A±zªºINDEXªº¥Îªk¡A§Úı±o«Ü¤£¿ù¡AÁÂÁ±z¡C