Finding the highest number from a list of random numbers

1. 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,

2. Re: Finding the highest number from a list of random numbers

here is one way edit i over thought that its easier just to use large

3. Re: Finding the highest number from a list of random numbers

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,

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1