Couple of ways to do that.
Add a "helper" column just before or just after your list.
In this column enter:
=RAND()
And drag down to copy as far as your list is.
Now, select your list, *including* the helper column, and do,
<Data> <Sort>
You can now pick the first 10 names as your random selection.
You can re-sort to get a new random order.
If the *original order* of your list is important, you could add another
column next to the rand column, number that 1 to 30, and then sort on that
column when you're finished, to revert the list to it's original order.
Another option is to use an out of the way column, say column Z, and enter
and copy down the RAND function to Z30.
Then, if your list of names was in Column A, from A1 to A30, enter this
formula where you would like to start a random order list, say C1:
=INDEX($A$1:$A$30,RANK($Z$1:$Z$30,$Z$1:$Z$30))
Drag down to copy to C10.
You now have your random order list of 10 names.
To get a *new* order, simply hit <F9>.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have a list of 30 names and addresses, and need to randomly select from
that list a total of 10 names .
