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,
Bookmarks