| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I randomise the order of a number of rows?
Hello Excel Gurus,
I have a spreadsheet containing a column of 100 items. I want to change from the original ordered state to a randomized state. One way would be to create a randomized column of numbers from 1 to 100 in an adjacent column, such that no number is repeated, then order the two columns by that list. Is there a way to do that? If I use RANDBETWEEN(1,100)I am certain to have a lot of numbers repeated. Is there a way around that? Thank You, -plh -- I keep hitting "Esc" -- but I'm still here! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
| how, in excel, can i generate a number, eg consecutive order nos | Excel Discussion (Misc queries) | |||
Threaded Mode
