µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ·j´M¬ÛÃö¸ê®Æ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
·j´M¬ÛÃö¸ê®Æ
sheau-lan
µoµu®ø®§
¥[¬°¦n¤Í
sheau-lan
·í«eÂ÷½u
UID
6725
©«¤l
96
¥DÃD
24
ºëµØ
0
¿n¤À
149
ª÷¿ú
149
ÂI¦W
0
§@·~¨t²Î
WINDOWES
³nÅ骩¥»
OFFICE
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
85 ¤p®É
µù¥U®É¶¡
2011-10-11
³Ì«áµn¿ý
2018-9-25
¤¤¾Ç¥Í
©«¤l
96
¥DÃD
24
ºëµØ
0
¿n¤À
149
ÂI¦W
0
§@·~¨t²Î
WINDOWES
³nÅ骩¥»
OFFICE
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-10-11
³Ì«áµn¿ý
2018-9-25
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2012-7-4 18:53
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
·j´M¬ÛÃö¸ê®Æ
§Ú·Qn¦bsheet1·j´Msheet2¸ê®Æ
¦p¦³¬ÛÃö¦r´N·|Åã¥Ü¦bsheet1¤º
½ÐÀ°¦£
001.zip
(1.88 KB)
¤U¸ü¦¸¼Æ:14
2012-7-4 18:53
¼Ó¥D¼ö©«
¬d¸ß°ÝÃD
ª©¦¸Åܧó°ÝÃD
½Ð°Ý²V¦X½s½X§ÚÀ³¸Ó«ç»ò°µ
§ì¨t²Î®É¶¡¦ý¿é¤J«á´N¤£¦b§ó§ï
¸ß¨D§ó¦nªºµ{¦¡
©w¸q°ÝÃD..½ÐÀ°¦£
¬Û¦ü¦r·j´M
·Q½Ð¦U¦ì¤j¤jÀ°¦£VBA
¬ÛÃöÅã¥Ü
¦³Ãöµû¤Àªº°ÝÃD
¦¬ÂÃ
¤À¨É
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
253
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4101 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-21
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
253
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-21
2
#
µoªí©ó 2012-7-4 23:12
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-4 23:29 ½s¿è
¦^´_
1#
sheau-lan
Sheet1!A3°}¦C¤½¦¡
=IF(ROW(A1)>SUMPRODUCT(ISNUMBER(FIND($B$1,Sheet2!$A$2:$A$6))*1),"",OFFSET(Sheet2!$A$1,SMALL(IF(ISNUMBER(FIND(Sheet1!$B$1,Sheet2!$A$2:$A$6)),ROW($2:$6),""),ROW(A1))-1,COLUMN(A$1)-1))
¦V¥k¦V¤U½Æ»s
¶i¶¥¿z¿ï¤]¬O«Ü¦nªº¿ï¾Ü
¤U¸ü
(552.65 KB)
2012-7-4 23:12
¸ê®Æ¬d¸ß¤]¦æ
¤U¸ü
(1.13 MB)
2012-7-4 23:29
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
sheau-lan
µoµu®ø®§
¥[¬°¦n¤Í
sheau-lan
·í«eÂ÷½u
UID
6725
©«¤l
96
¥DÃD
24
ºëµØ
0
¿n¤À
149
ª÷¿ú
149
ÂI¦W
0
§@·~¨t²Î
WINDOWES
³nÅ骩¥»
OFFICE
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
85 ¤p®É
µù¥U®É¶¡
2011-10-11
³Ì«áµn¿ý
2018-9-25
¤¤¾Ç¥Í
©«¤l
96
¥DÃD
24
ºëµØ
0
¿n¤À
149
ÂI¦W
0
§@·~¨t²Î
WINDOWES
³nÅ骩¥»
OFFICE
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-10-11
³Ì«áµn¿ý
2018-9-25
3
#
µoªí©ó 2012-7-5 19:31
|
¥u¬Ý¸Ó§@ªÌ
°}¦CÀ³¸Ó¬O§Ú·Qn£xµ²ªG.¤£¹L¸ê®Æ¶]°_¨Ó·|ºC¤@ÂI
¶i¶¥£x¸Ü´N³Â³Â¤@ÂI¨C¦¸³£n¿z¿ï¤@¦¸
¸ê®Æ¬d¸ß£x¤è¦¡§Ú°µ¹L£{¤£¹L¤£ª¾¹Dþ¥X£{®t¿ù.¹L¤@¬q´Á¶¡¸ê®Æ´N·|¶]±¼£{.¬d¤£¥X¨Ó.³£·|¸ò§Ú»¡¨S¦³³sµ²
¤£¹L³o¦¸£x°}¦C»P§Ú¤§«e³]©w£x¦³¤@¨Ç¤£¤@¼Ë.©Ò¥H§Ú¸Õ¸Õ¬Ý¦n¤F
ÁÂÁÂHsieh¤j¤j´£¨Ñ£{§Ú¨º£v¦h£x¸ê°T
TOP
ÀR«ä¦Û¦b :
µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·