Hi,

I have a column with 50 numbers and I want to sort them in a random order. I
had these number generated using =rand() but, I accidentaly put them in
ascending order. So, now I want to put them in a random order, it doesn't
need to be like before, just random.

Is this even possible??

Thanks in advance

With a helper column.

Put the =RAND() function in the helper cells on the same row as your values
and sort using that as the criteria. When done, delete the helper cells.




"Alex" wrote in message
...
Hi,

I have a column with 50 numbers and I want to sort them in a random order.
I
had these number generated using =rand() but, I accidentaly put them in
ascending order. So, now I want to put them in a random order, it doesn't
need to be like before, just random.

Is this even possible??

Thanks in advance