Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
how do i set up a list of names on a sheet frm various sheets in e | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Lookup cell value using list of worksheet names | Excel Worksheet Functions |