View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Help with randomly displaying values from a list.

Add a new column a put in thed new column

=RAND() and copy down colun

then highlight new column and copy and pastespecial value only. Next sort
on new column.

"Scott" wrote:

I have a list of 144 names. In a separate column, I want to break that list
up into groups of 4. Obviously, I know how to do that. But how do you
randomly select those names without duplicates?
For instance:
Names in Cells N7:N150.
Starting in cell C7 through C150, I want to randomly list those names.

Any help would be appreciated.