Material typo....

I wrote:
I am also bothered by the likelihood of duplicate results from RANDBETWEEN
due to quantization. But I can say with impunity that that is a real
problem.

I meant to write: "I can__not__ say with impunity ...". Klunk!


----- original message -----

"Joe User" <joeu2004 wrote in message
...
"James Silverton" wrote:
have a helper column, put randbetween(1, #values) in it

Using RANDBETWEEN incurs a lot of unnecessary overhead and the risk of a
#NAME error and confusion if the user is not familiar with the ATP (before
Excel 2007).

It is sufficient to fill the column with =RAND().

(I am also bothered by the likelihood of duplicate results from
RANDBETWEEN due to quantization. But I can say with impunity that that is
a real problem.)


----- original message -----

"James Silverton" wrote in message
...
random wrote on Sun, 25 Apr 2010 13:37:01 -0700:

does any know if sampling from a set can be done until all
values are selected?
One way would be to have a helper column, put randbetween(1, #values) in
it, replace the random numbers with values (paste special), sort and then
use the rest of the values sequentially.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not