+ Reply to Thread
Results 1 to 2 of 2

Quickest way to sort array alphabetically without looping

  1. 07-31-2017, 03:27 PM #1
    JasperD
    JasperD is offline
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Quickest way to sort array alphabetically without looping

    Hi all,

    I know I can sort an array alphabetically by looping through it - however, that's slow when you have a lot of values. As I have up to 2.6K, what would be the quickest way to sort them?
    Array -> Listbox -> Array?

    Thanks,

    Jasper
    Reply With QuoteRegister To Reply
  2. 07-31-2017, 03:44 PM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Quickest way to sort array alphabetically without looping

    This from another forum:
    stackoverflow.com/Quick-Sort for VBA

    ...and of course, Excel can sort a range VERY quickly.

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
    Last edited by leelnich; 07-31-2017 at 03:51 PM.
    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. most efficient and quickest way to populate data from sheet to array
    By twozedz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2016, 08:42 AM
  2. Sort Alphabetically
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-23-2015, 10:18 AM
  3. [SOLVED] Quickest way to gather unique values in column - preferably without looping
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-04-2015, 11:23 AM
  4. [SOLVED] Using an array formula to sort alphabetically over multiple columns
    By AliGW in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-14-2014, 02:13 PM
  5. [SOLVED] Sort Array Alphabetically
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2012, 12:03 PM
  6. sort alphabetically and numerically, then sort rows
    By luke20allen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2008, 07:00 AM
  7. Quickest Way of making an Array
    By WhytheQ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2006, 02:15 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