D
DABriggs
Is there anyway to keep the Rand function from duplicating
numbers?
numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
J
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.
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.
S
Stephen Bye
But if it never came up with duplicate numbers then it wouldn't be truly
random, would it?
random, would it?
J
JE McGimpsey
That's why it's called a pseudorandom generator...