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