Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help w/program to randomly sort row data
I've got an Excel worksheet with several columns of data. I want to randomly
shuffle all of the row data and then overwrite column A with sequential numbers down the column, 1...X, where X is the last row. Any ideas? Example: 1 B C D 2 G K L 3 D K C might become 2 G K L 1 B C D 3 D K C and then with column A renumbered, look like: 1 G K L 2 B C D 3 D K C I don't know much about Excel at all. How can I develop such a thing. Furthermore, can this also be done via a command line? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I randomly sort a column of data using Excel? | Excel Discussion (Misc queries) | |||
How do i sort rows randomly? | Excel Discussion (Misc queries) | |||
How do I randomly sort data in a column? | Excel Discussion (Misc queries) | |||
How do you randomly sort a RANGE | Excel Worksheet Functions | |||
I want to sort data randomly in addition to the current descendin. | Excel Worksheet Functions |