µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ½Ð°Ý¿é¤J¼ÆÈ¡A¤£¦P¤u§@ªí¥X²{ ÃC¦â?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
½Ð°Ý¿é¤J¼ÆÈ¡A¤£¦P¤u§@ªí¥X²{ ÃC¦â?
momo020608
µoµu®ø®§
¥[¬°¦n¤Í
momo020608
·í«eÂ÷½u
UID
22987
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ª÷¿ú
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
¦b½u®É¶¡
106 ¤p®É
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
¤¤¾Ç¥Í
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2017-9-9 17:20
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
½Ð°Ý¿é¤J¼ÆÈ¡A¤£¦P¤u§@ªí¥X²{ ÃC¦â?
½Ð°Ý
¦b¤u§@ªí¿é¤J ¼ÆÈ«á
¹ïÀ³¤£¦Pªº¤u§@ªí¡A§ä¨ì¬Û¦Pªº¼ÆÈ¡A·|Åã¥Ü©³¦â?
°ÝÃD.rar
(6.08 KB)
¤U¸ü¦¸¼Æ: 1
2017-9-9 17:19
ÁÂÁ¤j®a
¿é¤J¼ÆÈ
2089
3078
¦P®É ¹ïÀ³ªí®æ
·|¥X²{ ¶À¦â ©³¦â
¼Ó¥D¼ö©«
½Ð°Ý EXCEL ¦C¦L·f°t ÂI°}¦¡¦Lªí¾÷
¤Ï±À²Å¦X±ø¥óªº³Ì¤jÈ
Ë¼Æ ¼Æ¦r
½Ð°Ý Äæ¼e 1CM ¡A¦Û°ÊÅܦ¨0.98cm
¹A³¸p ¹A²£«~§åµo¥«³õ¦æ±¡¯¸-EXCEL ¥§¡»ù
½Ð°ÝEXCEL¦p¦ó¨Ï¼Æ¦r»yµÅª¥X
¹A¾ä¤ÀªR·f°t¦¯
½Ð°ÝEXCEL¥i¥H§â1234567890ÂনABCDEFGHIJ¶Ü
º}¯B¹Ï¤ù
¦p¦ó±qEXCEL¤¤¡A¿é¤J °Ñ¼Æ «á¡A¦Û°ÊºI¨úºô¶
¦¬ÂÃ
¤À¨É
momo020608
µoµu®ø®§
¥[¬°¦n¤Í
momo020608
·í«eÂ÷½u
UID
22987
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ª÷¿ú
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
¦b½u®É¶¡
106 ¤p®É
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
¤¤¾Ç¥Í
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
2
#
µoªí©ó 2017-9-9 17:48
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
momo020608
ª¾¹D¤F
®M¥Î¤½¦¡ ·s¼W³W«h
=COUNTIF(¿é¤Jªí®æ!$A:$A,A1)>0 ®M¥Î®æ¦¡
½Ð°Ý
¿é¤J¼ÆÈ ²£¥Í®É¶¡
·í¼ÆÈ¥X²{¡A´N²£¥Í ·í®Éªº®É¶¡¡A¸Ó¦p¦ó¤U¤â©O?
TOP
momo020608
µoµu®ø®§
¥[¬°¦n¤Í
momo020608
·í«eÂ÷½u
UID
22987
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ª÷¿ú
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
¦b½u®É¶¡
106 ¤p®É
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
¤¤¾Ç¥Í
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
3
#
µoªí©ó 2017-9-9 17:51
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
momo020608
¤Uz¤ù¬q¥\¯à¬OA¦C¥un¿é¤J¸ê®Æ,B¦C·|¦Û°Ê±a¥X¨t²Î®É¶¡
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
Select Case Target.Row
Case 60000: Target(-59998, 2).Select
End Select
If Target.Column = 1 Then
Target.Offset(0, 1) = Now
End If
End Sub
??¤£ª¾¹D¦p¦óקï
TOP
momo020608
µoµu®ø®§
¥[¬°¦n¤Í
momo020608
·í«eÂ÷½u
UID
22987
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ª÷¿ú
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
¦b½u®É¶¡
106 ¤p®É
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
¤¤¾Ç¥Í
©«¤l
45
¥DÃD
15
ºëµØ
0
¿n¤À
73
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2010
¾\ŪÅv
20
µù¥U®É¶¡
2015-12-13
³Ì«áµn¿ý
2024-7-17
4
#
µoªí©ó 2017-9-9 18:07
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
momo020608
½Ð°Ý
¦bEÄæ¦ì¿é¤J¼ÆÈ«á¡A¦p¦ó¦Û°Ê²£¥Í®É¶¡?
ªþÀÉ ÁÂÁ¤j®a
0909°ÝÃD.rar
(70.31 KB)
¤U¸ü¦¸¼Æ: 2
2017-9-9 18:06
TOP
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1387
¥DÃD
4
ºëµØ
0
¿n¤À
1397
ª÷¿ú
1397
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1746 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-11-12
¤j¾Ç¥Í
©«¤l
1387
¥DÃD
4
ºëµØ
0
¿n¤À
1397
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-11-12
5
#
µoªí©ó 2017-9-10 09:48
|
¥u¬Ý¸Ó§@ªÌ
®æ¦¡¤Æ»Ý¦P¶ ,©Ò¥H¿é¤J¼Æȳ]¦P¶©Î½Æ»s¨ì¦P¶JÄæ³]»²§U
J2¤U©Ô=¿é¤Jªí®æ!A2
®æ¦¡¤Æ=COUNTIF($J:$J,A1)
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
TOP
ÀR«ä¦Û¦b :
¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡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¯»µ·