µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
ÃÙ§U½×¾Â
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» «½Æ¤º®e®É¶¡¥[Á`¨Ã§R°£«½Æ«O¯d°ß¤@È
 
1
2
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
«½Æ¤º®e®É¶¡¥[Á`¨Ã§R°£«½Æ«O¯d°ß¤@È
v03586
µoµu®ø®§
¥[¬°¦n¤Í
v03586
·í«eÂ÷½u
UID
22132
©«¤l
183
¥DÃD
28
ºëµØ
0
¿n¤À
211
ª÷¿ú
211
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
¦b½u®É¶¡
239 ¤p®É
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2020-12-18
¤¤¾Ç¥Í
©«¤l
183
¥DÃD
28
ºëµØ
0
¿n¤À
211
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2020-12-18
11
#
¸õÂà¨ì
»
µoªí©ó 2020-12-15 03:14
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
9#
samwang
·PÁ«e½úªº«ü¾É, ¨âºØ¤è¦¡³£¦³¾Ç°_¨Ó!! ¥H«á¦³°ÝÃD¦A½Ð«e½ú¦h¦h«ü±Ð!!
TOP
n7822123
µoµu®ø®§
¥[¬°¦n¤Í
n7822123
(ªüÀs)
·í«eÂ÷½u
UID
20045
©«¤l
358
¥DÃD
8
ºëµØ
0
¿n¤À
405
ª÷¿ú
405
ÂI¦W
0
§@·~¨t²Î
WINDOWS 7
³nÅ骩¥»
2007
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
180 ¤p®É
µù¥U®É¶¡
2015-2-7
³Ì«áµn¿ý
2021-1-12
¡@¼ÊºÙ:
ªüÀs
¤¤¾Ç¥Í
©«¤l
358
¥DÃD
8
ºëµØ
0
¿n¤À
405
ÂI¦W
0
§@·~¨t²Î
WINDOWS 7
³nÅ骩¥»
2007
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2015-2-7
³Ì«áµn¿ý
2021-1-12
12
#
µoªí©ó 2020-12-15 19:59
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-12-15 20:07 ½s¿è
¦^´_
10#
v03586
§A·|¥Î
¦r¨åª«¥ó
ªº¸Ü¡A¾ÇSamwangªº¼gªk´N¥i¥H¤F
hcm19522¤j¤j¡A¤]ÃÒ©ú¤F¨ç¼Æ¥i¥H¸Ñ¨M99.99% ªº°ÝÃD
§Úªº¼gªk¥²¶·n¥ý¸g¹L±Æ¦C¡A¤£µM·|¦³°ÝÃD~~
¦^ÀY¬Ý§Ú¼gªºªF¦è¡A¼gªº¦³ÂI²ÖÂØ~~~²¤Â²¤Æ¦p¤U~
Sub ¥[Á`()
Dim Arr, PKey$, §R°£¦C As Range
Arr = [A1].CurrentRegion '§ìÀx¦s®æ¸ê®Æ ¨ì Arr °}¦C
Set §R°£¦C = Rows(UBound(Arr) + 1) '³o¦æ³æ¯Â¥u¬OÁ×§KUnion¸õ¥X¿ù»~¡A¥ý©wÓ½d³ò
For R& = 2 To UBound(Arr) '¤£¦PªºKey¬ö¿ýÀY¤@Ó¦C¸¹¡A¬Û¦PKey°µ²Ö¥[¡A°O¿ý¤§«án§R°£ªº¦C¸¹
Key$ = Arr(R, 9) & Arr(R, 10)
If Key <> PKey Then
R0& = R: PKey = Key
Arr(R, 13) = Arr(R, 12)
Else
Arr(R0, 13) = Arr(R0, 13) + Arr(R, 12)
Set §R°£¦C = Union(§R°£¦C, Rows(R))
End If
Next R
[A1].Resize(UBound(Arr), UBound(Arr, 2)) = Arr 'Arr¸ê®ÆË¦^¥hÀx¦s®æ
§R°£¦C.Delete '¥i§ï¬° §R°£¦C.Select ½T»{§R°£½d³ò
End Sub
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U
TOP
ÀR«ä¦Û¦b :
§Ú̳̤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
 
1
2
ªð¦^¦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¯»µ·