March 21st, 2010, 02:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|
How to get repeatable Excel RAND sequence?
On rereading your post I see you have already referenced KB828795 ...
I don't know of a way to seed the 2003 RAND function, or what the
algorithm is, but
http://support.microsoft.com/kb/828795
may help.
When I want a repeatable sequence of random numbers I generate a
range using RAND() and then copy-paste values to freeze the results.
Is there any way to seed (initialize) the Excel 2003 RAND function so that
subsequent calls to RAND result in a repeatable sequence?
|