Working with Random Text & Combining Cells
Louise,
Here is one formula that should work:
=INDEX($A$1:$A$137,RAND()*10)&","&INDEX($A$1:$A$13 7,RAND()*10)&","&INDEX($A$1:$A$137,RAND()*10)&","& INDEX($A$1:$A$137,RAND()*10)&","&INDEX($A$1:$A$137 ,RAND()*10)&","&INDEX($A$1:$A$137,RAND()*10)&","&I NDEX($A$1:$A$137,RAND()*10)&","&INDEX($A$1:$A$137, RAND()*10)&","&INDEX($A$1:$A$137,RAND()*10)&","&IN DEX($A$1:$A$137,RAND()*10)
Place this in B1 and copy down.
The Rand() function will return a random number and it will change whenever
the sheet recalculates. You can preserve the numbers once they are created by
copying the values in column B and then Paste Special: Values over the top.
Hope that helps.
"Louise" wrote:
Hello,
I have been reading everything I can and have not come up with the
solution and I am green to excel. Please assist me with this.
I have a list of 137 cells in A1:A137, each cell has data and none of
the cells are duplicates.
I want to randomly combine 10 of the cells together into B1:B137
separating each piece of data by a comma and repeat down the column so
that I have 137 cells with combined data.
Hope that makes sense?
Any help would be fantastic.
Thanks,
Louise
|