| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Number Generation
I need to generate a set of randow numbers but need it to not include any
numbers already generated for the range selected? i.e. Want numbers from 1-16 in 16 cells but don't want any duplicates. Any ideas? Thx. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Number Generation
If(?) you mean you want all 16 numbers 1-16 in a random order, with no
duplicates In B1:B16 enter 1 to 16 In A1:A16 enter formula =RAND() Press F9 a few times Sort A1:B16 with col-A as the sort key. Regards, Peter T "navel151" wrote in message ... I need to generate a set of randow numbers but need it to not include any numbers already generated for the range selected? i.e. Want numbers from 1-16 in 16 cells but don't want any duplicates. Any ideas? Thx. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Number Generation
Thx, Peter - as always it's something simple that works.
"Peter T" wrote: If(?) you mean you want all 16 numbers 1-16 in a random order, with no duplicates In B1:B16 enter 1 to 16 In A1:A16 enter formula =RAND() Press F9 a few times Sort A1:B16 with col-A as the sort key. Regards, Peter T "navel151" wrote in message ... I need to generate a set of randow numbers but need it to not include any numbers already generated for the range selected? i.e. Want numbers from 1-16 in 16 cells but don't want any duplicates. Any ideas? Thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random number generation | Excel Programming | |||
| Random Number Generation | Excel Programming | |||
| random number generation | Excel Worksheet Functions | |||
| Random number generation | Excel Programming | |||
| random number generation | Excel Worksheet Functions | |||
Linear Mode
