| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i sort rows randomly?
I want to choose 50 random rows from 10,000 lines of data and paste it into a
new sheet. The only way I know is to use a random number generator to randomly select the records and then copy/paste the data out out, row by row, fifty times, which is time-consuming. Is there a way to randomize my entire data table by row so that I can take the first fifty rows all at once and know that they've been randomly selected? Thanks. Jeremy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly Sort a Series of Numbers | Excel Discussion (Misc queries) | |||
| Why have I got some repeating rows after a Excel 2003 sort | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Can Excel sort rows by color? | Excel Discussion (Misc queries) | |||
| I want to sort data randomly in addition to the current descendin. | Excel Worksheet Functions | |||
Threaded Mode
