Hello!

I've been searching a soloution to my problem a very long time. And I still didn't get it.

For a new year lottery (on a small party) I've been trying to make lottery tickets with 4 unique numbers in range from 1 to 39.

There are 500 lottery tickets and in like 10 % of tickets the numbers in 4 columns are not unique. I know there has to be a solution.

So when a random number in column A is generated it mustn't be the same as in columns B,C and D, and when a random

number in column B is selected it mustn't be the same as in columns A,C and D etc.

Can someone modyfy formula in attached file to prevent duplicates?

Sincerelly thank you for your help!