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

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

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

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

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