Random Draw

  • Thread starter Thread starter ZZ
  • Start date Start date
Z

ZZ

Helloo Fellow members,

I need to know if there is a way I can make a random draw of names.
For example, I am arranging a snooker tournament of 12 peoples. All
the names are lets suppose listed in Column A, There will be Four
Groups consisting of 3 Names each. Group A, Group B, Group C, and
Group D.

What I need is to pick random names from Column A, and put them in
Groups.

Your help will be highly appreciated.

ZZ
 
Put this formula in column B next to your first name:

=RAND()

and copy this down. Then sort columns A and B using column B as the
key field. Then pick the top 3 to go into group A, the next 3 into
group B, and so on.

Hope this helps.

Pete
 
Hi Pete,

The formula u specified works for numbers only. greater than 0 and
less than 1. It does not work on names.
 
Hi Pete,

The formula u specified works for numbers only. greater than 0 and
less than 1. It does not work on names.





- Show quoted text -
Click to expand...

Oh.. I get it.. the random function assigns numbers to the names, and
than I have to sort the field to select names. Good short cut,
 
Top posting?

Is the problem sorting?

Try this to avoid sorting:

1. The 12 names are in cells A1 to A12
2. Type "=RAND()" into cell B1
3. Copy cell B1 into cells B2 to B12
4. Type "=CHAR(INT((RANK(B1,$B$1:$B$12)+194)/3))" into cell C1
5. Copy cell C1 into cells C2 to C12
 
Back
Top