View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_2_] James Silverton[_2_] is offline
external usenet poster
 
Posts: 115
Default Randomly populate a list into empty cells

Throme88 wrote on Tue, 1 Jul 2008 10:04:02 -0700:

What I have is a list of 20 word phrases that I need to be
randomly assigned to 6 empty cells. If anyone has any advice,
thank you.


Sort the phrases randomly (helper column with RANDBETWEEN(1,20), say)
and assign the first 6 in order.
--

James Silverton
Potomac, Maryland

E-mail, with obvious alterations: not.jim.silverton.at.verizon.not