Random numbers

  • Thread starter Thread starter Sal Iaccarino
  • Start date Start date
S

Sal Iaccarino

I need to generate 388 random numbers between 10000 and 65000, with a
minimum of 100 between adjacent numbers.
Can someone generate a formula to do this?

Thanks

Sal and Eileen
 
If you are wanting numbers that end in 00, then generate random numbers
between 100 and 650 then multiply them by 100.

If you also want no repeats, then list the numbers from 100 to 650 in
one column and place =RAND() in the corresponding cells of an adjacent
column. Sort both columns by the random column then use the first 388
numbers from the original column.

If instead you numbers with potentially any value in the units and 10s
positions, then you will need to define more completely what you mean by
random numbers with these restrictions.

Jerry
 
*Perhaps* this will do, or give you some ideas

In B1 Enter: 65000
In C1 Enter: =B1-101
In A1 Enter: =RANDBETWEEN(C1,B1)

Drag (copy) down x rows.

If you pop: =A2-A1 Into cell D2 and copy down you can tell if they are
spaced by at least 100.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top