generate formations of 15 random numbers, but must not have 14.15 points

[jorel]

generate formations of 15 random numbers, but must not have 14.15 points from the past draw list
so the macro cannot generate information that has 14 or 15 of any draws passed each week I will place new draws, and the macro has to filter
https://www.excelforum.com/attachmen...1&d=1580149409

[Richard Buttrey]

Sorry, but I just don;t understand your terminology or requirement

Pleas euplaod an example of what wouldn't be a valid series of numbers and explain why.

WHat do you mean by past draws. Do you mean all 1891?

[jorel]

ok richard, thanks for viewing the post, well, could do like this is generated a
* numbers of random 15-number formations
* then it would be filtered by the previous draws of noa 14 to 15 would be excluded, but I think the macro can also generate filtering in the list of draws
* example = 01 02 03 05 08 09 10 11 15 16 17 19 20 21 22, this formation has 14 repetitions of a draw, so it is excluded, it cannot have 14 or 15
* any previous draw or example
01 02 04 05 08 09 10 11 15 16 17 19 20 21 25,
* this form has 15 repetitions from one of the draws
* previous, then it is excluded, it cannot have 14 to 15 repetitions of the past drawings,
13 repetitions can

[Richard Buttrey]

What counts as a repetition?

You say the series
01 02 03 05 08 09 10 11 15 16 17 19 20 21 22

has 14 repetitions. I can find no repetitions when I filter the first column for 01, then the next for 02 then the 3rd 03.... etc

[jorel]

the macro has to compare with the list of draws, it is easy, as until now it has not repeated a draw with 15 points and with 14 very few, so any formation of 15 cannot be the same as the list of draws of 14

[Richard Buttrey]

I'm trying to understand the example you showed where you said there were 14 duplicates for the 15 number series you listed.

Filtering the data fir each of those column positions for the number you mentioned shows there is only one row with those numbers. How do you get 14 row all exactly the same?

[jorel]

hello richard, the probability of repeating 14.15 points from the draw list is very remote, this is what i talk about
* the randomly generated formation cannot equal 14, and 15 of the draws

[Richard Buttrey]

Are you now saying that what you said in #3 is not correct and there aren't 14 repetitions at all?

[jorel]

an example you generate 20 formations from 15 from 01 to 25 if one of them has 14 or 15 of the previous draws or is equal will be excluded

[Richard Buttrey]

Sorry but we're just misunderstanding each other.

You say there are 14 repetitions in the data you show. i.e. the 15 numbers in the same column positions, I don't see that.

Or are you saying that you start with no data at all and you want tp produce that list of 1891 rows. I had assumed you were continually adding a new row to the table and wanted to ensure that there were less than 14 repetitions.

[jorel]

you do not have to look at the positions, but the total of 14 or 15 cannot be equal to draws that have already occurred

[Richard Buttrey]

Would you comment on my last point. It's not clear whether the large data set you show is already in place and you want to check a new series yuo generate, or whether you start with a blank sheet and want to generate x number of rows.

[jorel]

ok Richard, thanks for viewing the post the list is from lotofacil lottery (brazil)
where we have 01 to 25, 15 are drawn, there are prizes for 15,14,13, what I want to avoid is playing games of 15 where I already have 14,15 of the draw lottery

[Kaper]

This is the old thread, but as I noticed it answering on a new topic (at the bottom of the webpage there is "Similar Threads" section) and the code for random generation of 15 out of 25 grawning can be recycled also here, so I did it.
The new thread is: https://www.excelforum.com/excel-pro...ml#post5747709
And the code is (the recycled part is used as a private sub):

Please Login or Register  to view this content.

Note that I added one column to your original file - the date of past lottery drawings. (filled this with any dates, you probably have real dates available). This allows to show not only that given generated combination was already (as a whole 15 or 14 numbers out of it) drawn but also show when and if it was dwand more than once list all dates - see row 17 in attached file

[jorel]

ok KAPER, CORRECT, thank you!