Finding the highest number from a list of random numbers

I am trying to find the highest numbers from a list of numbers (generated by the rand function). Certain character classes will have different requirements for their ability scores.

If I have 6 numbers

12
15
8
18
13
12

How could I assign the numbers to an order of values that could then be assigned to certain abilities. So from highest to least:

18
15
13
12
12
8

We have abilities:

Str
Int
Wis
Dex
Con
Cha

Some classes require higher strength, and dex others require higher intelligence and wisdom, etc. So for example a fighter would have,

Str 18
Dex 15
Con 13
Int 12
Cha 12
Wis 8

But a Wizard would use the numbers as such

Int 18
Cha 15
Con 13
Dex 12
Wis 12
Str 8

How would I go about creating this? I have an idea to use vlookup to form tables for the classes, such as fighter abcdef and wizard bfdeca.

Cheers,

Yes thank you for your response. What I ended up doing was a time sink but that's coo.

I set up the classes and ability scores as an index, then I generated a bunch of random values to fill the index, then I copied and pasted the index 25 times for the 25 characters.

Now I wonder if I can save all this data, heh heh,