View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Daniel.M Daniel.M is offline
external usenet poster
 
Posts: 32
Default Fastest way to sort large 2-D arrays?

Hi,

I think I worked this all out now.
Although it will need making an extra (the array holding the values to sort
on)


You could assign to new array sorted to the old one (depending on your needs).
arr = VSORTArray(arr,...)

Note that in cases of big arrays to sort and depending on the problem (you know,
I don't), it might be a good idea to look at VSORT.IDX function which only
returns 1 column wide of INDEXES, that is pointers to the indices of the 'rows'
as if they were sorted. It's a very powerful function.

Regards,

Daniel M.