Apache OpenOffice Community Forum

There has got to be a simple way.
What I'm trying to do. I want to randomly generate the numbers 1-6 without duplication.
So if A1 randomly comes up 4, I need B1 to be any number between 1-6 except 4. Lets say 2, now I need C1 to be any number between 1-6 except 4 and 2. And so on.

I'm just looking to generate a table 6 rows by 6 colums where each row has the numbers 1-6 generated randomly.

Now, I did a google search and found a macro for Excel called RandLotto which generates a given number of numbers from a given range, but of course it didn't translate.

Suggestions?

Coquihallagordon

Let A1:A6 be =RAND()
=RANK($A1;$A$1:$A$6) copy down.

Ok I entered =RAND() into cells A1 through A6
and entered =RANK($A1;$A$1:$A$6) in cells B1:B6

and it works perfectly. I don't claim to understand it, but it works. Thank you for your swift reply.
Gordon

You can also use =RANDBETWEEN(1;6)