HOW-TO make a random selection from a set of data and divide it into sub-team

[zanat0s]

Hi,

I need some help. I need to divide a group people in random teams an
have these groups reformed twice per month. here is an example. Lets sa
i have a group of 10 people and need to divide them in random teams o
2

A
1
2
3
4
5
6
7
8
9
10

I would like a result like 1-4, 2-10, 9-5, 7-6, 8-3 Which function ca
give a result like that? I need combinations of people where each perso
cannot be in more than one team.

Is it possible in Excel?

Thank yo

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Hi,

I need some help. I need to divide a group people in random teams an
have these groups reformed twice per month. here is an example. Lets sa
i have a group of 10 people and need to divide them in random teams o
2

A
1
2
3
4
5
6
7
8
9
10

I would like a result like 1-4, 2-10, 9-5, 7-6, 8-3 Which function ca
give a result like that? I need combinations of people where each perso
cannot be in more than one team.

Is it possible in Excel?

Thank you

Hi,

Have a look at the attached. Does this do what you mean?

Put your names in column C.
Column A allocates a random number between 1 & 10 to each name.
Column B ensures none of the numbers are repeated.
Columns F & J looks up the number in column B and returns the relevan
name.

To "randomise" it, just press the F9 key.

Hope that helps. Let me know if it's not quite what you need or if yo
need amendments.

S

+-------------------------------------------------------------------
|Filename: RandomTeamGenerator.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=434
+-------------------------------------------------------------------

 

[zvkmpw]

I need some help. I need to divide a group people in random teams and

have these groups reformed twice per month. here is an example. Lets say
i have a group of 10 people and need to divide them in random teams of
2

A
1
2
3
4
5
6
7
8
9
10

With the people in A1:A10, one way is to put
=RAND()
in B1:B10.

To randomize, select columns A:B and sort by column B. The teams are in A1:A2, A3:A4, A5:A6, etc.

Next time, randomize by sorting again.

Hope this helps.