help with sorting multidimensional array

[jyl7]

Hi,

I've got a multidimensional array that I don't know how to go about sorting... I have an MxN array, and I want the columns sorted in ascending order. There are some blank fields that I'd like to ignore too. I've added an attachment as an example. The tabs are pre-sorted data, and then another tab of what the sorted data should look like.

Thanks for your help

multi-sort-example.xlsx

[millz]

does all the data within columns D:K belongs to NAME as well?
or are they just independent columns of data to be sorted?

if they are not independent, then it's wrongly sorted.
if they are independent, how do you determine where to put blank fields? like in columns J:K, you have blanks on and off after sorted, while when before sorting they are all blanks before it comes to the data.

[jyl7]

D:K belongs to NAME as well.

On the AFtering sorting tab, what do you mean that it's wrongly sorted? They are still in ascending order (with blank fields ignored).

Utlimately what I want is for NAME to be in order, and B:K to be sorted in ascending order while ignoring blank fields.

[millz]

let's take a look at unknown3 for example, if all columns' data belongs to it, it means it has:

Please Login or Register  to view this content.

and after sorting, it has become:

Please Login or Register  to view this content.

doesn't it mean it has already lost its original data?

OR it could be im just dumb.... or your requirements on the sorting isn't clear enough?

Edit: also, from what i see, the column NAME isn't sort in an alphabetical order as well... so it's kind of confusing now

[jyl7]

oh, the sorting should be the columns, not the rows.

So, if you look at column B in the after sorting tab, it's in order. Same with C, D, E, F, etc.

Column A, NAME, is merely the labels that go with each of the values within a column.

[jyl7]

The column NAME is just a label and isn't supposed to be in any alphabetical order or numerical order. It's just supposed to correspond with the values in B:K

[Norie]

How did you achieve the sorting on the After Sorting sheet?

[jyl7]

I did it manually.

[jyl7]

Sorry it appears that my previous example file wasn't quite right. I've inserted the right file. Same rules apply.

multi-sort-example.xlsx

[Norie]

There seems to be some difference between the pre-sorted sheets in the workbooks, but the only difference in after-shorted shees only seems to be one has Others and the other doesn't.

Anyways, I can't see an easy way to sort as you want, the blanks being the main problem.

You certainly can't use Excel's inbuilt sort methods, manually or in code, as it doesn't like multiple areas.

Even writing code to sort the data isn't going to be straightforward.

[millz]

Link to solved thread, just in case any one arrived here instead.

[Norie]

So there was a duplicate thread?