| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unsorting a list
Can anyone tell me how to unsort a sorted list - eg when a list is imported
it is in alphabetical order, I want to change the order so that it becomes random. Does anyone know if this is possible. Thankyou |
|
#2
|
|||
|
|||
|
aehan, one way put =RAND() in the column next to your data, copy down, and
sort on that column -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "aehan" wrote in message ... Can anyone tell me how to unsort a sorted list - eg when a list is imported it is in alphabetical order, I want to change the order so that it becomes random. Does anyone know if this is possible. Thankyou |
|
#3
|
|||
|
|||
|
aehan wrote:
Can anyone tell me how to unsort a sorted list - eg when a list is imported it is in alphabetical order, I want to change the order so that it becomes random. Does anyone know if this is possible. Thankyou One approach is to create a helper column and fill it with randomly generated numbers using RAND(). Then sort everything using that randomly generated column as the key. Bill |
|
#4
|
|||
|
|||
|
Thankyou, that worked really well, both responses I had offered the same
solution which does exactly what I want it to. Much appreciated. Aehan "Paul B" wrote: aehan, one way put =RAND() in the column next to your data, copy down, and sort on that column -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "aehan" wrote in message ... Can anyone tell me how to unsort a sorted list - eg when a list is imported it is in alphabetical order, I want to change the order so that it becomes random. Does anyone know if this is possible. Thankyou |
|
#5
|
|||
|
|||
|
Your welcome, glad it worked for you
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "aehan" wrote in message ... Thankyou, that worked really well, both responses I had offered the same solution which does exactly what I want it to. Much appreciated. Aehan "Paul B" wrote: aehan, one way put =RAND() in the column next to your data, copy down, and sort on that column -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "aehan" wrote in message ... Can anyone tell me how to unsort a sorted list - eg when a list is imported it is in alphabetical order, I want to change the order so that it becomes random. Does anyone know if this is possible. Thankyou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Linear Mode
