Random number generation forming groups

saggikarius

New Member
Joined
Oct 24, 2005
Messages
23
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..
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,128
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
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
 

Forum statistics

Threads
1,181,658
Messages
5,931,270
Members
436,785
Latest member
KingGideon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top