[µo°Ý] ¨D§U~®É¶¡¿z¿ï¤ÎÀx¦s®æ¤º¦r¦ê¿z¿ï

Jason80Lo

½Ð±Ð¦U¦ì¤j¤j³Â·Ð¨ó§U¥H¤U»Ý¨D ¦p¤U¹Ï»¡©ú
ÁÂÁÂ~
20151226 »Ý¨D.rar (9.1 KB)

¤U¸ü¦¸¼Æ: 4

2015-12-26 11:29

¤U¸ü (30.36 KB)

2015-12-26 11:28

hcm19522

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

tku0216

¦^´_ 1# Jason80Lo

ªþ¥ó¨Ñ°Ñ¦Ò~
20151226 »Ý¨D.rar (8.1 KB)

¤U¸ü¦¸¼Æ: 6

2015-12-27 00:37

Jason80Lo

¦^´_ 3# tku0216


    ¤j¤j ¤£¦n·N«ä §ÚµLªk¤U¸ü ¦³§Oªº¤è¦¡¯àÅý§Ú¬d¬Ý¶Ü ÁÂÁÂ

­ã´£³¡ªL

¥Î¨â­Ó¤½¦¡¸û¬Ù¹Bºâ®Ä¯à¡A¤½¦¡¤]¸û²³æ©ö¸Ñ¡G

¢°¡D¥ý¨úÀɮצWºÙ¡A¢Ò¢³¡G°}¦C¤½¦¡¡]¹w³]ÀɮצWºÙ¤£·|¦³­«ÂС^¡@¡@
=INDEX($B:$B,SMALL(IF((RIGHT($B$3:$B$199,4)=D$2)*($A$3:$A$199-120000>0),ROW($A$3:$A$199),4^8),ROW($A1)))&""
¡@
¢±¡D«á¨ú®É¶¡¡A¢Ñ¢³¡G¤@¯ë¤½¦¡¡@
=IF(D4="","",INDEX($A:$A,MATCH(D4,$B:$B,)))

¢Ñ¢³¡G¢Ò¢³¤½¦¡«Ø¦n«á¡A¶K¨ì¢Ó¢³¡G¢Ô¢³¡A¦A¤U©Ô§Y¥i¡ã¡ã
¡@
¡Õ°}¦C¤½¦¡¿é¤Jªk¡Ö
¿é¤J©Î­×§ï¤½¦¡§¹¦¨«á¡A´å¼Ð¯d¦b¡e½s¿è¦C¡f¡A¥ý¤£­n«öEnter¡A¦P®É«ö¦í¡eShift + Ctrl¡f¤£©ñ¡A¦A«ö¡eEnter¡f¡C¡@

tku0216

¦^´_ 4# Jason80Lo

¥i°Ñ¦Òª©¥Dªº§@ªk¸û²³æ¡A§Úªº¤½¦¡¬O¦bC4Àx¦s®æ¿é¤J(¬d¸ß.jpg¸ê®Æ)¡G
=IFERROR(INDEX($A$1:$B$11,SMALL(IF((ISNUMBER(FIND("jpg",$B$3:$B$11,1)))*(TIME(LEFT($A$3:$A$11,2),MID($A$3:$A$11,3,2),RIGHT($A$3:$A$11,2))>TIME("12","00","00")),ROW($3:$11)),ROW()-3),COLUMN()-2),"")
¤§«áCtrl+Shift+EnterÅܦ¨°}¦C¤½¦¡¡A¤§«á¤U©ÔC4:D11¡C

¦A§âE4¿é¤J(¬d¸ß.txt¸ê®Æ)¡G
=IFERROR(INDEX($A$1:$B$11,SMALL(IF((ISNUMBER(FIND("txt",$B$3:$B$11,1)))*(TIME(LEFT($A$3:$A$11,2),MID($A$3:$A$11,3,2),RIGHT($A$3:$A$11,2))>TIME("12","00","00")),ROW($3:$11)),ROW()-3),COLUMN()-4),"")
¤§«áCtrl+Shift+EnterÅܦ¨°}¦C¤½¦¡¡A¤§«á¤U©ÔE4:F11¡C

Jason80Lo

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


    ÁÂÁ¦^´_ §Ú¬ã¨s¬Ý¬Ý