Unsorting a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
Thankyou, that worked really well, both responses I had offered the same
solution which does exactly what I want it to. Much appreciated.

Aehan
 
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
 
Back
Top