Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
How do I sort a list of cities in US by randomize in MS Excel or . | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |