+ Reply to Thread
Results 1 to 3 of 3

Sort array into ascending order - place special strings as first elements

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Sort array into ascending order - place special strings as first elements

    With this code, an array is placed into ascending order.
    I want to change the array order so that the strings staring with special character "§", are placed at the front.

    The order in the array is: 23, abc, to, §1, §2
    The order required: §1, §2, 23, abc, to

    Having issues with Sort_Again.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,517

    Re: Sort array into ascending order - place special strings as first elements

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Sort array into ascending order - place special strings as first elements

    @jindon, thanks very much, this is much smaller in size, and works as intended.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. FSO folder listing - ascending order - issue with special characters
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2020, 05:41 AM
  2. sort order of array elements into a matrix
    By Irina Spalko in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-23-2019, 12:18 PM
  3. add the quantity of each digit and put the strings in ascending order.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2019, 08:36 AM
  4. Non-Array formula to Remove Duplicates and Sort in Ascending Order
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2018, 02:59 PM
  5. [SOLVED] Separate strings of ascending order of 4 and 5 digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2017, 10:13 PM
  6. [SOLVED] Data validation special case (alphanumeric ascending order)
    By torers in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2015, 06:25 AM
  7. Sorting array variable elements ascending
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2011, 04:34 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1