Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I do a random excel sort or shuffle, in no particular order
I want to create several teams with different people on each team. I want
there to be no particular order to the way I sort the teams and I want excel to do this for me. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I do a random excel sort or shuffle, in no particular order
Terrih,
I would create a second column, with the formula =RAND() in each cell. Then sort all columns chosing the new column as the first to sort by. regards, PauwlL "terrih" wrote: I want to create several teams with different people on each team. I want there to be no particular order to the way I sort the teams and I want excel to do this for me. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I do a random excel sort or shuffle, in no particular order
Put you list in column A and in column B enter =RAND() and copy down the
column. Then sort A and B by B. This will shuffle column A -- Gary's Student "terrih" wrote: I want to create several teams with different people on each team. I want there to be no particular order to the way I sort the teams and I want excel to do this for me. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save my 'sort criteria' in an Excel file? | Excel Worksheet Functions | |||
Can I create a random order within a series of numbers in Excel? | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
how can i sort excel worksheets in alphabetical order? | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |