Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Groups
I don't know if there's a formula to randomly select names and
separete/divide them into groups. What i'm trying to do is that i have a list of names and i need to divide them into 20 groups of 2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Groups
Landin wrote:
I don't know if there's a formula to randomly select names and separete/divide them into groups. What i'm trying to do is that i have a list of names and i need to divide them into 20 groups of 2. You could put random numbers next to the names and sort on the number. Then you have 20 reasonably random pairs. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Groups
Would you please show me how to do that?
If possible describe everything by steps because i don't have a lot of experience with Excel... thank you in advance! "smartin" wrote: Landin wrote: I don't know if there's a formula to randomly select names and separete/divide them into groups. What i'm trying to do is that i have a list of names and i need to divide them into 20 groups of 2. You could put random numbers next to the names and sort on the number. Then you have 20 reasonably random pairs. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Groups
The step-by-step instructions might differ depending on the version of
Excel you are using, but hopefully this gets you close. Suppose your list of names is in column A. Next to the first name, in column B, put =RAND() Fill this formula down to the last name. This will generate a random number essentially between 0 and 1 on every row. With the cursor still in column B, use Data | Sort. The sort dialog will suggest you sort on column B ascending (you may wish to twiddle with the "my data range has header row | no header row" setting). Click OK. Your names will now be "sorted" by a random number. This might look a little confusing at first because the RAND function will recalculate when you do this... and the random numbers will no longer be sorted. If you want to fix the random number values permanently, select them, copy, then Edit | Paste Special, tick Values, and OK. Hope this helps! Landin wrote: Would you please show me how to do that? If possible describe everything by steps because i don't have a lot of experience with Excel... thank you in advance! "smartin" wrote: Landin wrote: I don't know if there's a formula to randomly select names and separete/divide them into groups. What i'm trying to do is that i have a list of names and i need to divide them into 20 groups of 2. You could put random numbers next to the names and sort on the number. Then you have 20 reasonably random pairs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
Row groups | Excel Discussion (Misc queries) | |||
SUM OF GROUPS | Excel Worksheet Functions | |||
show groups | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |