I have 20 people that I need to group in teams of 4 and would like for the
grouping to be random each time.
I have 20 people that I need to group in teams of 4 and would like for the
grouping to be random each time.
Hi
If the names are downwards in a column, put formula =RAND() in the cell
right to each name and sort by that column.
HTH. Best wishes Harald
"Ken P" <Ken [email protected]> skrev i melding
news:[email protected]...
> I have 20 people that I need to group in teams of 4 and would like for the
> grouping to be random each time.
If you wanted to break your original list of names into 4 groups, using 4
columns, say A1 to D5,
with your list of names say in Z1 to Z20, enter this formula in Y1 and copy
down to Y20:
=RAND()
THEN, enter this formula in A1, and drag across to D1,
Then down to D5:
=INDEX($Z$1:$Z$20,RANK(INDEX($Y$1:$Y$20,(4*ROWS($1:1))-4+COLUMNS($A:A)),$Y$1:$Y$20))
NOW, each time you hit <F9>, you'll get a new random grouping list.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken P" <Ken [email protected]> wrote in message
news:[email protected]...
>I have 20 people that I need to group in teams of 4 and would like for the
> grouping to be random each time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks