ExcelBanter - how do I create random blocks of letter and words in excel?

I'm sure that what you want can be done in Excel, however, I'm not sure
you've provided enough information to give you a solution. First off, what
is a block of 15? Is it a string of 15 characters, or 15 consecutive cells,
or a range of 5 cells by 3 cells? Second, can an individual block conain
duplicates from the list, or can each of the 30 values only appear once per
block?

That being said, here's a formula to extract a random character from your
list of 30. Assuming your list is stored in cells A1 through A30.

=INDEX($A$1:$A$30,INT(RAND()*30)+1)

Copy this formula to all cells in B1 through P24, and you've got 15 columns
of 24 random characters. If this is not what you need, then post back with
some examples.

HTH,
Elkar

"pencean" wrote:

For an experiment I am doing I have a list of 30 numbers and letters that I
need to place into 24 blocks of 15. Is there anyway to do this in Excel?