|
PureBytes Links
Trading Reference Links
|
Presuming you want a random mixture, use the random number generator to
generate random references to cells in the column of data you wish to mix.
For example, I have a spreadsheet where I wanted to mix up the sequence of
data in cells of column D, row 20:3637. So in column E, I put the formula
below. This is a sampling with replacement idea. I'm just giving you the
idea. You can figure out how to do it for a sampling without replacement.
Might have to use VBA.
=INDEX($D$20:$D$3637,RANDBETWEEN(1,3618))
Scott Hoffman
Issaquah, WA
-----Original Message-----
From: Massimo Ciarafoni <maxci@xxxxxx>
To: omega list <omega-list@xxxxxxxxxx>
Date: Monday, March 22, 1999 5:29 AM
Subject: Excel question
>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.
>Thanks in advance.
>
>--
>Best regards.
>
>Massimo.
>
>"You can't live a perfect day without doing something for someone who
>will never be able to repay you."
>- John Wooden
>
>
>
>
|