Random Draw

[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

 

[Pete_UK]

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

 

[ZZ]

Hi Pete,

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

 

[ZZ]

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 -

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,

 

[Henry]

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