ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

  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

¦^´_ 1# av8d

·N«ä¬O A2©MA10¬Û¦PªºCÄæ­È?
¸Õ¸Õ³o­Ó
  1. ActiveSheet.Columns("A:F").Sort Key1:=ActiveSheet.Range("C2"), Order1:=xlAscending, Key2:=[A1], Order:=xlAscending
½Æ»s¥N½X
­Y¤W¶ÇªþÀÉ¥i¯à·|§ó¤F¸Ñ§Aªº°ÝÃD
¥t¥~«Øij¤£­n¾ãÄæ¿ï°_¨Ó±Æ§Ç ®Ä²v·|«Ü®t=~=

TOP

¦^´_ 1# av8d
°ò¥»¤W¸ê®Æ§t¦³«D¼Æ­È¦r¤¸®É¡A´N¥H¤å¦r±Æ§Ç¡A­n¥H¼Æ­È±Æ§Ç¥²¶·¥[»²§UÄæ¦ì¨ú±o¼Æ­È¡AµM«á¥H¸Ó»²§UÄæ¦ì±Æ§Ç

    Sort.rar (8.53 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh


    ¥Ñ©óCÄæ°£¤F¦³A1~A20¥~~ÁÙ¦³B1~B20~©MC1~C20µ¥...
¦pªG§Ú±NtestÁôÂÃ~¬O§_¥i¥H°w¹ï¥L±Æ§Ç©O?ÁÂÁÂ!

TOP

¦^´_ 4# av8d
©ó¤u¨ã->¿ï¶µ->¦Û­q²M³æ ·s¼W ²M³æ  A1,A2,,,,A10,,,  ²M³æ  B1,B2,,,,B10,,,    ²M³æ  C1,C2,,,,C10,,,,      

Range("B2:B9").Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=12, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
        :=xlStroke, DataOption1:=xlSortNormal
-- OrderCustom:=12   --  12 ¬°²Ä¤@­Ó·s¼W²M³æªº¯Á¤Þ­È ¨Ì§Ç¬° 13 ,14....
·s¼W²M³æ

EX1.GIF
2012-8-19 21:17


±Æ§Ç¹Ï


EX2.GIF
2012-8-19 21:17

TOP

¦^´_ 5# GBKEE


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

§Ú°O±o¥H«e¦³¨Ï¥Î¹L~§Ú¦A§ä¬Ý¬Ý^^ ÁÂÁÂG¤j!

TOP

¦^´_  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!

TOP

¦^´_ 5# GBKEE


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

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-19 23:02 ½s¿è

¦^´_ 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))))),"")
play.gif
2012-8-19 23:02
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# Hsieh

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

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

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD