Thread
:
How to get repeatable Excel RAND sequence?
View Single Post
#
12
March 26th, 2010, 09:34 PM posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_]
external usenet poster
Posts: 184
How to get repeatable Excel RAND sequence?
Oops! I forgot to include the aux program dMod()
Function dMod(x, y)
dMod = x - Int(x / y) * y
End Function
x = dMod(x * a + b, k) / k
= = = = = = =
HTH :)
Dana DeLouis
Dana DeLouis[_3_]
View Public Profile
View message headers
Find all posts by Dana DeLouis[_3_]
Find all threads started by Dana DeLouis[_3_]