This is a little complicated. Will finish tonight.

"Sean" wrote:

there would be a total of 10 players master1 and man3 got a 5 so they would
be partnered up together. it is very confusing, the three categories will
not have the same number of players. a master could be a woman or a man it is
someone who has a certain average in our league. the ladies have secon draw
so the have a better chance of matching up with a master, then the men draw
the remaining cards(numbers). I hope this explains a little better.

"Joel" wrote:

The data you posted and your description don't agree so it is difficult to
produce the code you need. Also the Man column seems to be missing the
number 2.

I think you just need to assign a random numbers to each category and then
sort these numbers. There arre 2 Masters, so assign a random number between
1 and 2 to each Master. There arre 4 Ladies, so assign a Random number
between 1 and 4 to each Lady. There are 4 men, so assign a random number
between 1 and 4 to each man.
"Sean" wrote:

I am trying to randomize numbers for a dart tournament. I have 3 categories
Masters would draw cards first (a random number half of the total dart
players) then draw ladies (a random number half of the total dart players)
then men the remaining cards.

Master1 = 5 Lady1 = 2 MAn1 = 3
Master2 = 2 Lady2 = 3 Man2 = 1
Lady3 = 1 Man3 = 5
Lady4 = 4 Man4 = 4

Thanks in advance for your help!