How do I randomize a list without repeats

G

Guest

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
 
G

Guest

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Randomize a list 1
How do I randomize words within a row? 2
Randomize list of integers beteen 1-x with no repeats 5
Random list (1-45) without repeating numbers? 1
How do I randomize ascending data (number values) in excel? 1
Merging/Consolidating data? 2
Find repetive data and calculate 1
How do you randomize a list of questions in Word? 3

Top