RAND

[DABriggs]

Is there anyway to keep the Rand function from duplicating
numbers?

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/random.htm

 

[JE McGimpsey]

Since the cyclicality of RAND() is certainly greater than, say, the
number of rows, it's exceedingly unlikely to duplicate numbers unless
you're generating a huge simulation. In that case, XL's RAND function in
all versions is suspect enough that you should not use it for any
serious modelling work.

You may want to look at posts regarding RAND() in the archives

http://groups.google.com/advanced_group_search?q=group:*excel*

by Braden, Grove, Lewis and others.


Perhaps you're trying to do something different - post back if so.

 

[Stephen Bye]

But if it never came up with duplicate numbers then it wouldn't be truly
random, would it?

 

[JE McGimpsey]

That's why it's called a pseudorandom generator...