Looking for this...

[sangoma123]

Hello friends:

Today I would like to ask you for help for something that I believe that it is very difficult to do.

I don´t know if any program could do this, or if it is possible with Excel.

I explain it:

Let's imagine that I have in a Excel Spreadsheet, approximately 400-500 combinations of Euromillions (5/50).

Let's imagine also we play approximately 18-24 numbers of 50.

What I would like to obtain is the minimal necessary bets in order that every number appears in the final combinations, (equal or minor to 15 bets), a minimum of 2 times.

I am doing this habitually to hand, but it is very tedious.

I don´t know if it is possible to do it with Excel, though I have the impression of not.

Have you got any idea of since is it possible to do this?.

Thank you very much, like always.

Regards

 

[Icewynd]

Not quite sure what you are after, Sangoma. Are you trying to write out all the combinations that can be created from your selected numbers?

If so, I think I have seen macros referenced on these forums that would do that.

Good luck!

 

[sangoma123]

Hello Icewynd:

Thanks for your interest. I´m working in it.

I see that your brain don´t stop.("Cold numbers elimination")

Thanks anyway.