ExcelBanter - Array Sort on 2 keys

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Array Sort on 2 keys (https://www.excelbanter.com/excel-programming/349290-array-sort-2-keys.html)

Nigel

Array Sort on 2 keys

Hi All
I have an array with two dimensions, typically 36 by 2. Is there a
procedure for sorting an array by the two variables in the second dimension?
Or would it be simpler to write the array to a worksheet and use sort, then
reload the array?

--
Cheers
Nigel

RB Smissaert

Array Sort on 2 keys

You can do that with Laurent Longre's xll add-in:
http://xcell05.free.fr/
But maybe it is simpler to sort in a sheet.

RBS

"Nigel" wrote in message
...
Hi All
I have an array with two dimensions, typically 36 by 2. Is there a
procedure for sorting an array by the two variables in the second
dimension?
Or would it be simpler to write the array to a worksheet and use sort,
then
reload the array?

--
Cheers
Nigel

All times are GMT +1. The time now is 04:39 AM.