Save Random Number
[reposting]
On Oct 18, 12:20 pm, Paul B. wrote:
I would like to generate a row of 5000 - unique random
numbers and not have them change once generated.
Irritating, isn't it?
One way: Create a UDF that calls the VBA function Rnd(),
Another way: After generating the column using =RAND(), copy the column,
then use Paste Special -- Values to replace the column with the generated
values.
|