+ Reply to Thread
Results 1 to 7 of 7

Arrange data in ascending order

  1. 04-17-2016, 08:55 AM #1
    bezbid
    bezbid is offline
    Registered User
    Join Date
    04-26-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2003 2007
    Posts
    69

    Arrange data in ascending order

    I have data in Column A,

    0001.HO
    0003.TL
    00085.KY
    00095.AW
    0008.HO
    0018.TL
    00023.KY
    .......

    what is the vba to arrange them ascending order by the letters after the ".", so the result is

    00095.AW
    0001.HO
    0008.HO
    00023.KY
    00085.KY
    0003.TL
    .......
    Reply With QuoteRegister To Reply
  2. 04-17-2016, 09:07 AM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Arrange data in ascending order

    Does data has header ?
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 04-17-2016, 09:15 AM #3
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Arrange data in ascending order

    If you use a helper column and use =right(A1) fill to the bottom of your list, then sort.

    Here is a simple clip on that, https://youtu.be/FChVzq0DOOI
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  4. 04-17-2016, 09:20 AM #4
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Arrange data in ascending order

    Assuming it is possible to use column "B" and there is NO header, try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-17-2016, 09:46 AM #5
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Arrange data in ascending order

    Another way without the use of column "B"

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-17-2016, 10:16 AM #6
    bezbid
    bezbid is offline
    Registered User
    Join Date
    04-26-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2003 2007
    Posts
    69

    Re: Arrange data in ascending order

    thank you, sry for the late reply, there is no header in column A
    Reply With QuoteRegister To Reply
  7. 04-17-2016, 10:22 AM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Arrange data in ascending order

    A remake without error

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] any way to arrange the categories on a bar chart by ascending/descending order
    By tukae in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-26-2015, 08:01 AM
  2. [SOLVED] Re-Arrange Data Ascending
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-11-2015, 08:52 AM
  3. how to arrange multiple columns in ascending order
    By sanjay2210.msl in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 08:26 AM
  4. Arrange the sheet name in ascending order
    By PRADEEPB270 in forum Excel General
    Replies: 2
    Last Post: 05-13-2013, 08:08 AM
  5. How to arrange in ascending order all subtotals
    By faisal123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2013, 06:12 AM
  6. Arrange Data on Pivot table in Ascending order
    By Excel Dumbo in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 08:53 PM
  7. Sorting Data in ascending order
    By sharon2006 in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 09:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1