As Myrna Larson points out, if you need to sort by two columns, you want
a stable algorithm and quicksort won't do. The likely candidates are
radixsort (aka counting sort) or mergesort. I can send you either or
both of these in VBA, but are the fields you need to sort on numbers or
strings?

Dave Ring

agarwaldvk wrote:
Hi All


Whilst Excel sorting is extremely quick, I sometimes have a need to
sort arrays (and reasonably large ones at that say of the order of
30000 Excel rows and 10 Excel columns sorted by 1 or 2 columns). I
tried to do that in VBA Excel for an array of 5500 rows and 10 columns
and it took around 5 minutes but Excel sorted the same data in less
than a minute. So in this instance, I did take that option but this may
not be always possible or feasible!

I am advised that quicksort is pretty efficient for unsorted data
(whilst performing poorly for nearly sorted dataset - which more than
likely would never be the case for my dataset) and counting sort is
lighting fast, can anyone help me write (relatively easily) a VBA code
for either of these sort procedures or gulde me to a website where some
assitance can be available?

For the reason stated above, I would additionally like to be able to
sort arrays using one of the 2 alternatives, if possible!

Any assistance or help shall be highly valued.


Best regards


Deepak Agarwal