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!