Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randbetween
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randbetween
Hi,
Without resorting to code you could put the numbers 1 to 65 in column A Then the formula =Rand() in column B and drag down to Row 65 Select column A & B and sort on column B. The top 31 numbers in column A are guaranteed unique and within your range Mike "Steve Moss" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
randbetween(1.1,1.25) | Excel Worksheet Functions | |||
RANDBETWEEN | Excel Worksheet Functions | |||
RANDBETWEEN | Excel Discussion (Misc queries) | |||
Randbetween | Excel Discussion (Misc queries) | |||
randbetween gives ?NAME | Excel Discussion (Misc queries) |