i have 31 cells which have the following formula: =RANDBETWEEN(1,65). i.e.
they all generate a random number between 1 and 65, this number relates to a
row on another sheet.
what i am trying to do is work it so each box generates a random number
which doesnt get repeated in any other box, what do i need to add to the
formula for this to be possible.