| 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. |
| 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) | |||
Threaded Mode
