G Guest May 2, 2006 #2 Put the names in a column (say from A1 thru A18) in B1 thru B18 enter: =RAND() Sort the data by column B. This shuffles the names in column A. Just pick the top six. To get another sample just re-sort and pick the top six again.
Put the names in a column (say from A1 thru A18) in B1 thru B18 enter: =RAND() Sort the data by column B. This shuffles the names in column A. Just pick the top six. To get another sample just re-sort and pick the top six again.
