| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Randomly sorting an Excel spreadsheet
Use a help column, assume the names are in A starting in A2, insert a
temporary B column and put =RAND() in B2, copy down by double clicking the lower right corner of the cell with the formula, select all columns that need to be sorted and sort by the help column, remove the help column -- Regards, Peo Sjoblom "tcufrogdawn" wrote in message ... How can I randomly sort an Excel spreadsheet containing names? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORTING AN EXCEL SPREADSHEET ROW BY ROW | Excel Worksheet Functions | |||
| Randomly sorting the alphabet | Excel Discussion (Misc queries) | |||
| Sorting in Excel spreadsheet | Excel Discussion (Misc queries) | |||
| In excel spreadsheet my comment boxes change sizes randomly why? | Excel Worksheet Functions | |||
| Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
