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
|