Random number generation forming groups

[saggikarius]

Hello Friends,

We are a group of 42 people who are pursuing their higher studies. We have to divide each one of us into seven groups. The groups have to be divided in a batch of 6 for giving group presentatinos.

I know theres are rand function available but not sure how should I use this for this purpose.

Each time we want to give the presentation, the groups should be different and randomly selected.

Something like:
Group One - 1,18,42,31,21,28
Group Two - 3,11,2,23,15,17
And so on....

Please help.. Thanks..
Saggik..

 

[dave3009]

Hi There

What you can do is list all your names in a list in say column B say B2:B43

Then in cell A2 you have formula =RAND() copy it down

Then sort the data using column A, everytime you sort the data it will produce a totally random list for you.

HTH


Dave