Number generator without historical draw

Elek — Fri, 31 Jul 2020 12:21:47 GMT

Hi everybody

I turn to you because I have a question.

The following document lists the extracted numbers and a generated list.

I ran into drawing lots of numbers that had already been played.

How could the number strings that have already been drawn be filtered out in the generator?

So some cleverness should be added to the code below!

Thanks for the help.

I don't know how to put a picture.

(C3: I103) - historical data

(L3: R13) -generated data

Sub allgen... [ More ]