Random Number Generator

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry Divers - 09 Oct 2003 13:29 GMT

I would like to generate random numbers (10 at a time)
from a list of numbers in range a1:a70. Is there an Excel
or VBA solution please
Barry

Reply to this Message

Dave Peterson - 10 Oct 2003 00:40 GMT

Put =rand() in B1:B70.
Sort A1:B70 by column B.
Choose the first 10.
Hit f9 to recalc (if you want) and resort.

If you really want some VBA, Myrna Larson has posted a shuffle routine a few
times.

http://google.com/groups?threadm=fjtl9vsune4hll8avgvu3vb7r8sufi5mg5%404ax.com

> I would like to generate random numbers (10 at a time)
> from a list of numbers in range a1:a70. Is there an Excel
> or VBA solution please
> Barry

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message