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

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

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

¤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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# paul3063


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/KhGkDA
E0127_1.png
2017-12-9 10:49

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# joblyc017


ÁÂÁ±z

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

TOP

¦^´_ 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

TOP

¦^´_ 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),),))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 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),"")),)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# hcm19522


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

TOP

¦^´_ 8# Hsieh


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

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD