Unsorting a list

A

aehan

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
 
P

Paul B

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
 
G

Guest

aehan said:
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
Click to expand...


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
 
A

aehan

Thankyou, that worked really well, both responses I had offered the same
solution which does exactly what I want it to. Much appreciated.

Aehan
 
P

Paul B

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
 
Top