Is there any script that I generate 6 numbers of these numbers from the list?

Is there any script that I generate 6 numbers of these numbers from the list? so they do not recur after another example 7,12,13,19,26,33





https://www.dropbox.com/s/hu5q7h2qkl...lotto_svk.xlsx

I am not sure what you are trying to do. Could you explain what you are trying to achieve so that we can give you a valid solution. The worksheet does not provide an inkling of what you want. Please clarify.

Hi Dragon,

See if the attached does what you need. Click the button and it will pick 6 numbers from 1 to 49 and do it again so none of the last 12 numbers are the same.