random pick names from the list
 

what formula can i use to choose names from the list then put in
different group?

example:

a1 - a130 130 names
b1 - b30 group 1
c1 - c30 group 2
d1 - d30 group 3
e1 - e30 group 4
f1 - f30 group 5

i want random pick name from a1-a130, put the first 30 picks in group
1, then next 30 in group 2 until all name been picked.

thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=555564

random pick names from the list
 

ne way:

Move your groups to columns C to G

in column B put =RAND() and copy down to 130

sort columns A & b based on B

In c1 put =A1 and copy down 30
in d1 put = A31 and copy down 30
etc

you can delete column B

hth

"jinvictor" wrote:


what formula can i use to choose names from the list then put in
different group?

example:

a1 - a130 130 names
b1 - b30 group 1
c1 - c30 group 2
d1 - d30 group 3
e1 - e30 group 4
f1 - f30 group 5

i want random pick name from a1-a130, put the first 30 picks in group
1, then next 30 in group 2 until all name been picked.

thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=555564