for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations.

[piter]

for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations.
Lottery Basics:
7 numbers from 31. Order does not matter.
03 05 08 09 19 21 30
08 11 12 14 20 21 28
11 12 21 24 25 28 29
06 07 13 15 18 19 29
02 08 09 17 19 24 28
01 11 18 19 26 30 31
02 05 06 14 20 24 25
01 04 13 21 22 24 27
03 10 13 18 19 23 24
06 10 13 18 19 20 30
07 13 16 19 20 27 31
02 03 07 12 17 21 22
01 04 07 09 20 21 26
01 08 16 20 21 26 31
08 11 13 16 26 28 29
01 02 07 12 16 20 25
09 11 13 14 19 20 22
04 07 08 14 21 27 31
03 04 09 12 14 28 29
06 12 17 21 26 29 31
02 08 10 11 12 18 31
02 04 05 12 18 22 27
09 10 17 19 25 27 28
07 08 12 15 16 18 30
01 10 13 17 21 25 29

 

[piter]

note = every week will be placed
new raffles, and the macro has to include
in the new calculation