|
PureBytes Links
Trading Reference Links
|
At 12:39 PM 3/22/99 +0100, you wrote:
>Is there a way in Excel to mix up the cells of a column in a way to get
>all the same cells but in a different sequential order?
>I.e. from 1,2,3,4 to perhaps 2,4,1,3.
One way to do this is to create a parallel column, fill it with random
numbers, and sort based on the new column. Voila, randomized cells. Useful
for randomizing observations to extract test sets and such for neural nets
and other similar creatures.
--
Dennis Nichols
nichols@xxxxxxxxxxxxxxxxxxxxxx
|