I am trying to make 4 numbers in a random order. They must be unique.
So I have tried using the standard <> (Not equal to) but it does not seem to work but itself. I have put brackets around the formulas to see if i can test it using True/False, does not work
a long ways around this would be to make a list of 4 numbers 1-4 and then randomly take out one number at one position at a time and delete that position , then the next one would only randomise between 3 numbers ect ect . I have done this before but i did not think it was optimal.
This is what I have come up with on the last test , but there are duplicates
Any comments will be appreciated
So I have tried using the standard <> (Not equal to) but it does not seem to work but itself. I have put brackets around the formulas to see if i can test it using True/False, does not work
a long ways around this would be to make a list of 4 numbers 1-4 and then randomly take out one number at one position at a time and delete that position , then the next one would only randomise between 3 numbers ect ect . I have done this before but i did not think it was optimal.
This is what I have come up with on the last test , but there are duplicates
Any comments will be appreciated