| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
random numbers, how can you utilize it without repeating them
How can you use random numbers without repeating them on a worksheet? The way
it is set up now is, example: =RANDBETWEEN(1,8) I would like to be able to use the random between but I don't want the numbers to repeat themselves within the worksheet. Any suggestions or Ideas? |
|
#2
|
|||
|
|||
|
http://www.mcgimpsey.com/excel/udfs/randint.html
-- Regards, Peo Sjoblom (No private emails please) "RS" wrote in message ... How can you use random numbers without repeating them on a worksheet? The way it is set up now is, example: =RANDBETWEEN(1,8) I would like to be able to use the random between but I don't want the numbers to repeat themselves within the worksheet. Any suggestions or Ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| random numbers from a data of numbers? | Excel Worksheet Functions | |||
| Help on Random Numbers | Excel Discussion (Misc queries) | |||
| Validating random numbers | Excel Worksheet Functions | |||
| Random Numbers Change? | Excel Worksheet Functions | |||
Linear Mode
