random selector

[billy561]

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?

 

[Weaver]

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?

 

[billy561]

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

 

[AhoyNC]

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.