µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» excel Àx¦s®æªº³]©w°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
excel Àx¦s®æªº³]©w°ÝÃD
ahsiek
µoµu®ø®§
¥[¬°¦n¤Í
ahsiek
·í«eÂ÷½u
UID
13371
©«¤l
48
¥DÃD
8
ºëµØ
0
¿n¤À
60
ª÷¿ú
60
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
office2010
¾\ŪÅv
20
¦b½u®É¶¡
36 ¤p®É
µù¥U®É¶¡
2013-4-9
³Ì«áµn¿ý
2019-12-17
¤¤¾Ç¥Í
©«¤l
48
¥DÃD
8
ºëµØ
0
¿n¤À
60
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
office2010
¾\ŪÅv
20
µù¥U®É¶¡
2013-4-9
³Ì«áµn¿ý
2019-12-17
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-1-27 11:41
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
excel Àx¦s®æªº³]©w°ÝÃD
½Ð°Ý¤@¤U¡AÀx¦s®æªº³]©w¸Ì¡AY A1 - B1 ªºµ´¹ïÈ >1 ®É¡AC1 ·|Åܦ¨¬õ¦â¨Óĵ¥Ü
§Ú¼gªº¤èªk¬O C1= ABS(A1-B1)¡AµM«á¦b³]©w®æ¦¡¤Æ±ø¥ó¸Ì¡A³]©w¬° >1 ¡A«hÀx¦¡®æ¶ñº¡¬õ¦â
¨ì³o¸Ì¬O¨S¦³°ÝÃD
°ÝÃD¬O¡AY§Ú»Ýn¬O C1È>1
¤@ª½«ùÄò5¬í¥H¤W¡A¤~°µÄµ¥Üªº¸Ü
¡A§Ú¸Ó«ç»ò¼g¤~¦n¡C(A1©MB1ªº¼ÆȬO¨C¬í¦bÅÜ°Ê)
¥i¥H³Â·Ð¼ô±xexcel³]©wªº¤j¤jÌ¡A¥i¥HÀ°À°¦£¶Ü¡HÁÂÁ¡C
¼Ó¥D¼ö©«
Àx¦s¤£·|¦Û°Ê°±¤î¡A¸Ó«ç»ò§ï¡H
VBA °ÝÃD¨D±Ð
excel Ãþ¦ü®É¶¡½X¿ö¼gªk¦p¦ó¼g
¦p¦ó¥Îvba»s§@°Ê§@°±¤îªº´£¥Ü§iª¾
excel 2013ª©¥»DDE³sµ²ªº°ÝÃD
office365 excel °O¿ý¼ÆÈ
excel 365 ¿W¥ß¶}±Ò¼ÆÓ¬¡¶Ã¯
¦¬ÂÃ
¤À¨É
fantersy
µoµu®ø®§
¥[¬°¦n¤Í
fantersy
·í«eÂ÷½u
UID
19564
©«¤l
132
¥DÃD
35
ºëµØ
0
¿n¤À
179
ª÷¿ú
179
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
Taiwan
¦b½u®É¶¡
76 ¤p®É
µù¥U®É¶¡
2014-12-24
³Ì«áµn¿ý
2024-8-2
¤¤¾Ç¥Í
©«¤l
132
¥DÃD
35
ºëµØ
0
¿n¤À
179
ÂI¦W
0
§@·~¨t²Î
Windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
Taiwan
µù¥U®É¶¡
2014-12-24
³Ì«áµn¿ý
2024-8-2
2
#
µoªí©ó 2015-1-28 11:48
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
ahsiek
³o¥i¯àn¥Î¨ìVBA¤F...¥i¥H¥hµ{¦¡°Ï°Ý¬Ý¬Ý!!
TOP
ahsiek
µoµu®ø®§
¥[¬°¦n¤Í
ahsiek
·í«eÂ÷½u
UID
13371
©«¤l
48
¥DÃD
8
ºëµØ
0
¿n¤À
60
ª÷¿ú
60
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
office2010
¾\ŪÅv
20
¦b½u®É¶¡
36 ¤p®É
µù¥U®É¶¡
2013-4-9
³Ì«áµn¿ý
2019-12-17
¤¤¾Ç¥Í
©«¤l
48
¥DÃD
8
ºëµØ
0
¿n¤À
60
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
office2010
¾\ŪÅv
20
µù¥U®É¶¡
2013-4-9
³Ì«áµn¿ý
2019-12-17
3
#
µoªí©ó 2015-1-28 11:52
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
fantersy
¦nªº¡AÁÂÁ§A¡C
TOP
ÀR«ä¦Û¦b :
¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú̧óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ùÈ¡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¯»µ·