Hello!

I have been struggling with this all afternoon, and was hoping someone could help!

I am trying to sort an array (size is 3 x 10) with the following data

The first column has a country name, and the second column has total score. The array is a Variant type (as I will have both the name and data); and as per example below, I have loaded the data so that Cell (1,1)= Australia, and Cell(2,1)= "27" therefore there is no need to transpose when printing to screen.

I want to sort the array by total score, so that the country with the highest score is in the first row (and the one with the lowest score is in the last row of the array).

Secondly, once I have sorted the array, I want to assign a rank to each country based on whether it is in the top third of scores, middle third of scores or bottom third of scores.

Lastly, I want to print this array onto a new worksheet for the user to see.

Example of my array before sort:
Country name Score
Australia 27
Austria 40
Benin 3
Canada 35

Example of array after the sort

Austria 40 ..... 1
Canada 35 ...... 2
Australia 27 ....... 2
Benin 3 ....... 3

Thanks so much! I am a newcomer to VBA (and computer programming) so appreciate all the help!

Cheers!
Sunita