Unique Random Number Generator

[Tom Barnes]

I'm looking for a macro that will generate a unique Random number between
1-2000. The random aspect is obviously not the problem, the unique
requirement is whats got me stumped. Thanks Tom.

 

[0-0 Wai Wai ^-^]

What about using RANDBETWEEN function?
It is not a macro but it appears to suit your need.

RANDBETWEEN(bottom,top)

Bottom is the smallest integer RANDBETWEEN will return.

Top is the largest integer RANDBETWEEN will return.

Example


1
2
3
A B
Formula Description (Result)
=RANDBETWEEN(1,100) Random
number between 1 and 100 (varies)
=RANDBETWEEN(-1,1) Random
number between -1 and 1 (varies)



So in your situation, you can use =RANDBETWEEN(1,2000).
Press "F9" to generate a random number again.

PS: You need to install "Analysis ToolPak add-in" to have this function enabled.

 

[JE McGimpsey]

Unique how? as in all the numbers from 1-2000 will cycle in a single
cell before repeats? Or as in multiple cells with no repeats?

You might get something you need at

http://www.mcgimpsey.com/excel/randint.html

Or specify more exactly what you need.

 

[Jerry W. Lewis]

If you want a random sampling without replacement of n<=2000 integers
between 1 and 2000, then put the numbers 1 to 2000 in A1:A2000, put
=RAND() in B1:B2000, then sort A1:B2000 by B1:B2000 and take the first n
numbers from A1:A2000.

Jerry

 

[Dave Hawley]

Hi Tom

Try this page. Should get you there

http://www.ozgrid.com/VBA/RandomNumbers.htm

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***