ªð¦^¦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

¦^´_ 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´§
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

¦^´_ 12# Asterl


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

TOP

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

TOP

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

¥»©«³Ì«á¥Ñ 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

¦^´_ 5# GBKEE


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

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

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD