View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marston Marston is offline
external usenet poster
 
Posts: 43
Default Multi-column two-dimensional quick sort

Hi -

I've gone through many of the old posts on quick sorting and haven't
quite come across what I think would solve my problem.

I have a very large array that has been loaded from multiple
worksheets.
In general, its somewhere in the neighborhood of 100,000 rows x 10
columns.

What I'd like to do is sort all the information based first on the
values in each of the rows and one of the columns and then within that
set, sorting on a second column, and so on until the entire array has
been sorted by each of the columns.

What I've seen will sort on any one column within a 2-d array, but not
multiple columns.

Thanks in advance