Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This may be hard to do and a deck of cards may be my only answer
In Column A I have a list of names - potentially up to 32 (never any more) What I need to be able to do is go thru that list and generate 4 even groups, so for example if there were 20 names in the list it would generate 4 groups of 5 randomly picking the members for each group The results for each group need to be placed in columns E,I,M,Q starting at cell 1 in each coumn If there are 19 people in the group then it would generate 3 of 5 and 1 of 4 Thanks for any assistance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generate random number from a list | Excel Worksheet Functions | |||
Need to generate random values from a list | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
generate a random list with 3 options | Excel Programming |