How do I randomize a list without repeats

I have a listing ordered from 1 to 1596 that I would like to re-order -
randomize such that no one item in the list is repeated.
I am using Microsoft Office Excel 2003

Hi,
Let's say that your list is in A1:A1596. Create a helper column, say
B1:B1596 as follows:
In B1, enter the formula =RAND(), and drag the formula down the column to
B1597. Select B2:B1596, and in the SAME column, "Copy" --> "Edit
Special"-->"Values".
Now select both the columns and sort by column B (ascending or descending).

Regards,
B. R. Ramachandran

"K9CE" wrote:

> I have a listing ordered from 1 to 1596 that I would like to re-order -
> randomize such that no one item in the list is repeated.
> I am using Microsoft Office Excel 2003
>

WOW - Thank you every so much - I do struggle sometimes, for some reason when
I tried to do this "my way" I kept getting repeats - again thank you,
Maurice (K9CE)

"B. R.Ramachandran" wrote:

> Hi,
> Let's say that your list is in A1:A1596. Create a helper column, say
> B1:B1596 as follows:
> In B1, enter the formula =RAND(), and drag the formula down the column to
> B1597. Select B2:B1596, and in the SAME column, "Copy" --> "Edit
> Special"-->"Values".
> Now select both the columns and sort by column B (ascending or descending).
>
> Regards,
> B. R. Ramachandran
>
> "K9CE" wrote:
>
> > I have a listing ordered from 1 to 1596 that I would like to re-order -
> > randomize such that no one item in the list is repeated.
> > I am using Microsoft Office Excel 2003
> >