Hi, Is there at all a way to sort (numerically) a multidimensional array?

I have an array that is as follows

`dim points(23,1) as String`

The first dimension of the array has the players names in, the second dimension of it has their cumulative points, so I want to sort the array by points and maintaing the correlation of players name to points (if that makes sense)

thanks in advance!

5 Years
Discussion Span
Last Post by G_Waddell

You could try a different method and define a structure.....

Dim stud(24) As Students
Dim tmpStud As Students

Structure Students
    Dim StudentName As String
    Dim CumulativeScores As Double
End Structure

    For i = 0 To stud.Count - 2
        If stud(i).CumulativeScores > stud(i + 1).CumulativeScores Then
            tmpStud = stud(i + 1)
            stud(i + 1) = stud(i)
            stud(i) = tmpStud
        End If

Edited by Begginnerdev


Or you could use a SortedList and not have to do the sort yourself.

Dim mylist As New SortedList

mylist.Add("John", 23)
mylist.Add("Jim", 14)
mylist.Add("Fred", 92)

For Each key As String In mylist.Keys
    Debug.WriteLine(key & ": " & mylist(key))

Edited by Reverend Jim: added sample code

Votes + Comments
Nice, I didn't even think of SortedList

Thanks for the input guys, I assume it would be possible to populate the sorted list from a multidimensional array?


Thanks Jim, once again you have provided a useful way of solving a problem.

Also thanks BegginnerDev for your input

Edited by Quinncunx


One final comment on SortedLists. If the item you want to sort is not a primitive data type (String, Integer, etc) then you have to specify a user-written function that compares two elements and returns a value of -1, 0, or 1. This custum function is then used by SortedList to do the sort. You would need to do this if (as BeginnerDev suggested) you created a structure to hold your data.

If you have your answer then please mark this thread as solved.


If Sortedlist doesn't work for you you can also try a DataTable. A DataTable has a DefaultView property, which is a DataView for the table and a DataView has a Sort property which allows you to sort your data by any column in either direction e.g. "PlayerPoints Desc"

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.