# Group picker

#### Sheepskin_Coat

##### New Member
hi i have 80 teams and i want to randomly pick them in to 10 groups of 8 teams.

I have used the rand and rank and vlookup, but i get the same team in different groups,what can i do

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi

If you use =RAND() to return a random number in an adjacent column to the team names, then copy & paste values you could simply sort on the results of this column (either ascending or descending) and then you have your 10 groups every 8 rows.

Hi

If you use =RAND() to return a random number in an adjacent column to the team names, then copy & paste values you could simply sort on the results of this column (either ascending or descending) and then you have your 10 groups every 8 rows.

I have done this and it works, but is there any why do put the results of the draw onto another sheet also is there any why to use a macro to do the draw when i press a shape as a button

is there any why do put the results of the draw onto another sheet
Yes. Use Copy, Paste, or Copy, Paste Special, Values.
Or use a linking formula such as
Code:
``=Sheet1!A1``
also is there any why to use a macro to do the draw when i press a shape as a button
Yes. Do the draw manually yourself, but just before you do it, use Tools, Macro, Record New Macro to record the steps you take and build them into a macro automatically. When you've finished the draw, use Tools, Macro, Stop Recording. Then draw a button and simply assign your new macro to that button.

is there any why do put the results of the draw onto another sheet
Yes. Use Copy, Paste, or Copy, Paste Special, Values.
Or use a linking formula such as
Code:
``=Sheet1!A1``

Thanks for that, but when i do that it still changes, how do i stop it change till i press the button

Replies
4
Views
542
Replies
0
Views
333
Replies
5
Views
146
Replies
5
Views
1K
Replies
1
Views
365

Threads
1,196,189
Messages
6,013,938
Members
441,796
Latest member
kmag

### 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

### 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