| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non updatable Unique Random Number
What is the relationship between the number of records
and the number of iterations I have to do? I tried 400 records and, in the formula, changed 2000 to 400. I had to iterate 625 times before the numbers became unique. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Non updatable Unique Random Number
I am afraid that I don't know, it has always been trial and error with me.
Perhaps someone else does know. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Herbert Seidenberg" wrote in message oups.com... What is the relationship between the number of records and the number of iterations I have to do? I tried 400 records and, in the formula, changed 2000 to 400. I had to iterate 625 times before the numbers became unique. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Non updatable Unique Random Number
The number of iterations seem to depend on the ratio of records
to the range of security numbers allowed. I chose a ratio of 1 to 10 and the number of necessary iterations dropped to 4. Here is my modified formula for 400 records: =IF(($A$1="")+(AND(B10,COUNTIF($B$1:$B$400,B1)=1) ),B1, RANDBETWEEN(1000,5000)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| I need a unique number to be created per worksheet | Excel Discussion (Misc queries) | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| VB Random Number Generation/Insertion/NextWorksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
