# random selector

#### billy561

##### New Member
In column A2:A31 I have 30 numbers, the highest being 53. How do I select 6 random numbers 50 times with no repeat sequences?

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Welcome to the board.

I'm thinking you might need a bit of custom vb for that.

Would the sequences be 'random order' too? In other words would you sort them or would 1,2,3,4,5,6 represent a different sequence to 5,6,1,2,3,4

Also, can you duplicate a number or a selection in a 5 digit sequence?

Is this anything to do with lottery numbers?

I would sort them in assending order and yes 1 2 3 4 5 6 & 2 3 4 5 6 1 would be a duplicate, 1 2 3 4 5 7 would not. yes it is lottery numbers for a debate a friend and I are having on random selection with less than all the numbers in a lottery used as apposed to all the numbers used. Could one produce more returns than the other? I'm weak on my Excel formulas

If you are just looking for the total number of outcomes without repeats and 1,2,3,4 = 4,3,2,1 then you could just use the combination formula in Excel.

<TABLE style="WIDTH: 107pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=143><COLGROUP><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5229" width=143><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 107pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20 width=143>=COMBIN(30,6)</TD></TR></TBODY></TABLE>
This would tell you there are a total of 593,775 different outcomes.

Not sure of your question because if you used all the numbers and 1,2,3,4 is the same as 4,3,2,1 then there would only be 1 outcome with all 30 numbers.

Replies
3
Views
110
Replies
0
Views
73
Replies
5
Views
177
Replies
3
Views
455
Replies
1
Views
79

1,203,045
Messages
6,053,188
Members
444,644
Latest member
keepontruckinc4

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

### Which adblocker are you using?

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

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