ML089

C1¬O 1~12¤ë¥÷ ¤å¦r¿ï³æ

D1 =HYPERLINK("#"&SUBSTITUTE(D1," ",)&"!A1","ÂI¿ï¸õ¦Ü --> "&D1)
«öD1¤~¯à¸õ¦Ü­n±o¤u§@ªí

ML089

¦^´_ 3# ws2315

°Ñ¦ÒÀÉ®×
¸õ¦Ü¨ä¥L¤u§@ªí.rar (6.92 KB)

¤U¸ü¦¸¼Æ: 29

2016-11-13 09:36

ML089

¦^´_ 5# ws2315

»Ý­n¥ÎVBA¨Ó§¹¦¨

ML089

¦^´_ 13# ws2315


    20161231 ¤£¦P¤é´Á¡B ®É¶¡¤§¥[Á`.rar (9.45 KB)

¤U¸ü¦¸¼Æ: 12

2016-12-31 15:53

ML089

¦^´_ 7# ws2315

VBA§Ú¤£¼ô
¥i¥H¥tPO¨ìEXCEL VBA µ{¦¡°Ï¡A¨ºÃä°ª¤â¦h

¦^ÂЭn«ö©ó¤U¤è«ö "¦^ÂÐ"¡A³o¼Ë¤~¯à³qª¾§A­n°Ýªº¤H¡A¤j®a¤£¨£±o¨C¤é¤Wºô°Q½×¡A¤@¤£¤p¤ß´Nº|±¼¤F¡C

ML089

¦^´_ 16# ws2315

»Ý­n´ú¸Õ1.xlsÀɮפ@¨Ö¶}±Ò¤½¦¡¤~¯à§ìªº¨ì

­Y­n¨Ì¨C¤é¥h§ì¡A³]A5¤½¦¡©Î±N¸Ó¤½¦¡¨ú¥N­ì¤½¦¡¤¤ªºA5
A5 =TEXT(TODAY(),"e¦~m¤ëd¤é")

ML089

¦^´_ 18# ws2315


    A5 =TEXT(TODAY(),"e¦~m¤ëd¤é")
³oÀ³¸Ó¬O«Ü²³æªº³]©w
¿Ë¤â°µ°µ¬Ý

ML089

¦^´_ 22# ws2315

=SUMPRODUCT(OFFSET($C$5:$C$424,,MATCH($R9,$1:$1,)-2),(--OFFSET($B$5:$B$424,,MATCH($R9,$1:$1,)-2)>=--LEFT(S$5,4))*(--OFFSET($B$5:$B$424,,MATCH($R9,$1:$1,)-2)<=--RIGHT(S$5,4)) )

¤½¦¡¤¤ $1:$1 ¸ê®Æ¦ì¸m¤é´Á¦C¤w¸g²¾¦Ü3¦C¡A½Ð§ï¬° $3:$3
¥t¥~MATCH($R9,$1:$1,)¨S¦³§ä¨ì¤é´Á¤]·|¿ù»~

ML089

¦^´_ 25# ws2315


S9 =SUMPRODUCT(OFFSET($C$5:$C$424,,MATCH($R9,$3:$3,)-1),(--OFFSET($B$5:$B$424,,MATCH($R9,$3:$3,)-1)>=--LEFT(S$5,4))*(--OFFSET($B$5:$B$424,,MATCH($R9,$3:$3,)-1)<=--RIGHT(S$5,4)) )
¤½¦¡¥k©Ô

MATCH($R9,$3:$3,)-1 ¡A¤½¦¡¬d¸ß¤é´Áªº¦ì¸m§@¬°OFFSETªº¤ô¥­°¾²¾¶q¡C
OFFSET($C$5:$C$424,,MATCH($R9,$3:$3,)-1) ¡A$C$5:$C$424¬°106¦~1¤ë12¤éªº¼Æ¶q¦ì¸m¡A¨ä OFFSETªº¤ô¥­°¾²¾¶qÀ³¸Ó¬°0¡A
¦ý¥ÎMATCH($R9,$3:$3,)¬d¸ß¤é´Á¦ì¸m®É¬°1¡A¦]¦¹«á­±-1´N¬O­×¥¿¬°0ªº°Ñ¼Æ¡C·í¸ê®Æªí®æ¦³¤ô¥­²¾°Ê®É»Ý­n­×¥¿¦¹°Ñ¼Æ¡C

ML089

book1.rar (27.46 KB)

¤U¸ü¦¸¼Æ: 8

2017-1-13 13:35