Working with Random Text & Combining Cells
Oops,
Sorry Louise, posted too quick.
In that formula, please change the " *10 " after the Rand() function to "
*137 ".
Please leave out the quotation marks. So the formula should read:
=INDEX($A$1:$A$137,RAND()*137)&","&INDEX($A$1:$A$1 37,RAND()*137)&","&INDEX($A$1:$A$137,RAND()*137)&" ,"&INDEX($A$1:$A$137,RAND()*137)&","&INDEX($A$1:$A $137,RAND()*137)&","&INDEX($A$1:$A$137,RAND()*137) &","&INDEX($A$1:$A$137,RAND()*137)&","&INDEX($A$1: $A$137,RAND()*137)&","&INDEX($A$1:$A$137,RAND()*13 7)&","&INDEX($A$1:$A$137,RAND()*137)
Hope THAT works.
"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
|