### [Solved] 4 unique, but random numbers

Posted:

**Thu Dec 05, 2019 1:21 pm**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!

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!