+ Reply to Thread
Results 1 to 4 of 4

sort an array ascending

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    boston
    MS-Off Ver
    Excel 2010
    Posts
    42

    sort an array ascending

    Is there a built in function to sort an array ascending order. The array would contain nurmeric values.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,673

    Re: sort an array ascending

    If you mean a native VBA function to sort an array in memory, no.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: sort an array ascending

    no there isn't. there are many sorting algorithms and sample code available however. you can also use ranges to sort the data if you wish
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: sort an array ascending

    Does this answer your question...

    On the home tab >> Editing >> Sort & Filter

    or you can right click on the array and then Sort
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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