[µo°Ý] »¼¼W±Æ§ÇA1~A10¡A¦p¦óÅýA1«á­±¬OA2¦Ó¤£¬OA10¡C

av8d

1. 'A:F»¼¼W±Æ§Ç
   
2.     ActiveSheet.Columns("A:F").Select
   
3.     Selection.Sort Key1:=ActiveSheet.Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
   
4.         OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
   
5.         :=xlStroke, DataOption1:=xlSortNormal

½Æ»s¥N½X

¥H¤W¬O»¼¼W±Æ§Çªº¥¨¶°~
¦ý¬O±Æ§Ç«á~¸ê®Æ¤º¦³A1.XXXXX~A10.XXXXXXX
»¼¼W±Æ§Ç~«o¬O
A1.XXXXX
A10.XXXXX
A2.XXXXXXX

¦p¦óÅý¥¦Åܦ¨
A1.XXXXXX
A2.XXXXX

ML089

¦^´_ 10# av8d

±Æ§Ç³Ì¦n¨Ì·ÓEXCELªº¼ç³W«h¨Ó³B²z

³oºØµLªk±Æ§Ç
1.XXXX
2.XXXX
8.XXXX
11.XXXX
´N§ï¬°³oºØ¤è¦¡
01.XXXX
02.XXXX
08.XXXX
11.XXXX  

³oºØµLªk±Æ§Ç
A1
A2
A11
´N§ï¬°³oºØ¤è¦¡
A01
A02
A11

¦p¦ó­×§ï:  ¥Î¤H¤u§ï¡B¥Î¤½¦¡§ï¡B¥Îµ{¦¡§ï
°£¤F¤H¤u§ï¥~¡A¨ä¥L¥Ñ¦U¦ì°ª¤â¨Óµo´§

taiabc1234

¤å¦r©M¼Æ¦r¦X¦b¤@°_
execl·|±N¨äµø¬°¤å¦r

av8d

¦^´_ 12# Asterl


    A¤j~ÁÂÁ§A~¾Ç²ß¤F^^

Asterl

¦³¤@­Ó¤ñ¸û²³æªº¤èªk¡A
´N¬O±NA1¡BA2...
§ï¦¨A01¡BA02...¡BA10
§Y¥i§ïµ½¡C

Hsieh

¦^´_ 10# av8d
¤£½×¦p¦ó¡A´N¬O­n¨Ï¥Î»²§UÄæÂ^¨ú¥X¼Æ­È³¡¤À¦A¥h±Æ§Ç¡A¤~¯à¹F¨ì§Aªº»Ý¨D

av8d

¦^´_ 9# Hsieh

¦pªG¬O¤@¯ë
1.XXXX
2.XXXX
8.XXXX
11.XXXX

«ç»ò±Æ§Ç«o¬O
1.XXXX
11.XXXX
2.XXXX
8.XXXX

Hsieh

¦^´_ 8# av8d
G2=--SUBSTITUTE(A2,MID(A2,1,LOOKUP(2,1/ISERROR(--MID(A2,ROW(INDIRECT("A1:A"&LEN(A2))),1)),ROW(INDIRECT("A1:A"&LEN(A2))))),"")

¤U¸ü (336.72 KB)

2012-8-19 23:02

av8d

¦^´_ 5# GBKEE


    ¦n¹³¤£¯àA1~A20¥BB1~B20¥BC1~C20~
¬O¦]¬°¹Lªø?

av8d

¦^´_  GBKEE


    §Úªº¬O2010ª©~¥i¬O§ä¤£¨ì¿ï¶µ->¦Û­q²M³æ->¶×¤J

§Ú°O±o¥H«e¦³¨Ï¥Î¹L~§Ú¦A§ä¬Ý¬Ý^^ ...
av8d µoªí©ó 2012-8-19 21:46

    §ä¨ì¤F~¿ï¶µ->¶i¶¥->½s¿è¦Û­q²M³æ~ÁÂÁÂG¤j!