Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create random blocks of letter and words in excel?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change letter case without having to retype words? | Excel Discussion (Misc queries) | |||
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? | Excel Discussion (Misc queries) | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel |