µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ¦X¨ÖÀx¦s®æ¼Ð¥Ü§Ç¸¹»P¤ÀÃþ²Îp
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¦X¨ÖÀx¦s®æ¼Ð¥Ü§Ç¸¹»P¤ÀÃþ²Îp
Andy2483
µoµu®ø®§
¥[¬°¦n¤Í
Andy2483
(«pÁy¥Öªº¾Ç¥Í)
·í«eÂ÷½u
UID
36777
©«¤l
1446
¥DÃD
40
ºëµØ
0
¿n¤À
1470
ª÷¿ú
1470
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
1428 ¤p®É
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-10-21
¡@¼ÊºÙ:
«pÁy¥Öªº¾Ç¥Í
¤j¾Ç¥Í
©«¤l
1446
¥DÃD
40
ºëµØ
0
¿n¤À
1470
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-10-21
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2023-7-13 07:47
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¦X¨ÖÀx¦s®æ¼Ð¥Ü§Ç¸¹»P¤ÀÃþ²Îp
¦U¦ì¼ö·R¾Ç²ßªº½×¾ÂªB¤Í̦¦w
ÁܽФj®a¤@°_¾Ç²ß ¦X¨ÖÀx¦s®æ¼Ð¥Ü§Ç¸¹»P¤ÀÃþ²Îp ¥DÃD
°õ¦æ«e:
¤U¸ü
(131.17 KB)
2023-7-13 07:44
§Æ±æ°õ¦æµ²ªG:
¤U¸ü
(139.59 KB)
2023-7-13 07:45
20230713.zip
(25 KB)
¤U¸ü¦¸¼Æ: 18
2023-7-13 07:45
¼Ó¥D¼ö©«
½Ð±Ð ¤½¦¡_¸õÄæ¨Ã¥B²Å¦X±ø¥ó¤~¥[Á`
Excel VBA¦p¦óÀˬd_§t¦³µù¸Ñ®æ¼Æ¶q
Excel VBA¦p¦ó §Ö³t¨ú®ø¦X¨ÖÀx¦s®æ_ªÅ®æ¶ñ¤J
½Ð±Ð VBA ¦p¦ó¤é´Á+®É¶¡Âà¤Æ¬°¤å¦r
Excel VBA¦p¦óÀˬd_§t¦³®æ¦¡¤Æ±ø¥óÀx¦s®æ¼Æ
¾î¦¡¸ê®ÆÂà´«¬°ª½¦¡¸ê®Æ_¦U±è¦¸¦W³æ
½Ð±Ð ¤½¦¡_¸õÄæ¥[Á`
¦Û°Ê¤W©³¦â»P¦r¦â ¨Ã¦Û°Ê½Õ¾ã¤Ï®t©ö©óÃѧO
Excel¬O¦p¦ó§P§O¨Ï¥Îªº¸ê®Æ¦C¬O§_³sÄò
©Þªe¤ñÁɹڤ۶¤¥î
¦¬ÂÃ
¤À¨É
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
Andy2483
µoµu®ø®§
¥[¬°¦n¤Í
Andy2483
(«pÁy¥Öªº¾Ç¥Í)
·í«eÂ÷½u
UID
36777
©«¤l
1446
¥DÃD
40
ºëµØ
0
¿n¤À
1470
ª÷¿ú
1470
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
1428 ¤p®É
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-10-21
¡@¼ÊºÙ:
«pÁy¥Öªº¾Ç¥Í
¤j¾Ç¥Í
©«¤l
1446
¥DÃD
40
ºëµØ
0
¿n¤À
1470
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Excel 2010 & 2016
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2020-7-15
³Ì«áµn¿ý
2024-10-21
4
#
µoªí©ó 2023-7-17 08:29
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
hcm19522
¦^´_
3#
oscarsun72
ÁÂÁ¤G¦ì¦^´_
¤½¦¡°õ¦æµ²ªG:
¤U¸ü
(96.01 KB)
2023-7-17 08:23
¦ò¦Û¤ß¤¤¨Ó,¦³½t¤H¶·¦Û´ç
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
TOP
oscarsun72
µoµu®ø®§
¥[¬°¦n¤Í
oscarsun72
·í«eÂ÷½u
UID
39909
©«¤l
7
¥DÃD
0
ºëµØ
0
¿n¤À
54
ª÷¿ú
54
ÂI¦W
53
§@·~¨t²Î
Windows10
³nÅ骩¥»
Office 2016
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
»O¥_
¦b½u®É¶¡
62 ¤p®É
µù¥U®É¶¡
2023-4-20
³Ì«áµn¿ý
2024-7-10
¤¤¾Ç¥Í
©«¤l
7
¥DÃD
0
ºëµØ
0
¿n¤À
54
ÂI¦W
53
§@·~¨t²Î
Windows10
³nÅ骩¥»
Office 2016
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
»O¥_
µù¥U®É¶¡
2023-4-20
³Ì«áµn¿ý
2024-7-10
3
#
µoªí©ó 2023-7-16 21:00
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ oscarsun72 ©ó 2023-7-16 21:02 ½s¿è
µÐÂÄ·O´d¡G¸Ì±°£¤F½d¨Ò¸ê®Æ¨S¦³§OªºªF¦è°Ú¡H¥H¡@µÐÂızªºµ{«×·|°µ¤£¥X¨Ó¶Ü¡H¤£¤Ó¥i¯à§a¡C·P®¦·P®¦¡@«nµLªüÀ±ªû¦ò
¼Ó¤Wµ¹ªº¤½¦¡§Úµw®M¨ìAÄæ¡A¦n¹³¤]¤£¦æ¹À¡CÁÙ¬O¥½¾Ç¤£¦æ©O¡H¤½¦¡§Ú´N´X¥G¤@¬¤£³q¤F¡FVBA«j±jÁÙ¥i¡CªüÀ±ªû¦ò
³oÁÙ¬O¥½¾Ç¯à¦b¦¹µoªº²Ä¤@©«¡]ñ¤F¦n´X¤Ñªº¨ì¤~±Ã¨Óªº¡^¡CºF·\¡C·P®¦·P®¦¡@«nµLªüÀ±ªû¦ò
¬°¤°»òÁ٥Ϊ©ExcelÀÉ¡A¬O¤è«K¥¨¶°ªºÀx¦s»P°õ¦æ¶Ü¡H¡]ªþ¥óÀɤ¤¥ç¨ÃµL¥¨¶°¡^
·P®¦·P®¦¡@«nµLªüÀ±ªû¦ò
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®É¶¡
1748 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-11-22
¤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-22
2
#
µoªí©ó 2023-7-14 16:07
|
¥u¬Ý¸Ó§@ªÌ
=COUNTIFS(A:A,"<>",B:B,J2)
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
TOP
ÀR«ä¦Û¦b :
¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶Ãµ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¯»µ·