Clustering Matrix values- how to sort and index?

Dear all,

I am trying to code a Macro which utilizes the Direct Clustering Algorithm.
As input, I have a binary matrix.
For example:

Please Login or Register  to view this content.

[note that the first row and column are headers]

Now, the rows of the matrix are interpreted as a binary value, which then should be sorted descendingly:

First: Sort rows

Please Login or Register  to view this content.

The row wise sorted matrix then should be sorted columnwise, also descendingly.

Please Login or Register  to view this content.

What I have so far is the preperation to have arrays with the binary values stored:

Please Login or Register  to view this content.

What now puzzles me is: how to I sort an array and efficiently save its index, so I can swap the rows and columns? And also, if the problem gets bigger, lets say a matrix with 100+ columns and rows, does my way of concatenating the cells still work? I am already getting overflow errors when I use integers for the arrays arraybinC and arraybinR, I hope double arrays have enough storage...

Maybe someone can help me, that would be aweseome Please find a sample attached. (in the first sheet there is a sample problem, in the second there is how I imagine the code should work like)

BTW: If someone knows the last step, how to determine cluster and colour the matrix accordingly, please feel free to tell me As of now, I am trying to get the matrix first

Thank you so much and have a nice weekend!

This will sort the array myArray.
Note that myArray is declared as a module wide variable.
(Note also that the first bit of code that gets the test data should be altered to get the data from your source. The sorting stuff begins where indicated)
(Note also that if you are using more than 10 columns, you need to adjust (or remove) the final output line)

The code sets up an array arrRows and then sorts that on which row is greater.
It then re-orders myArray according to that sort.
Then it does the same thing with arrCols and columns.

Please Login or Register  to view this content.