sort numbers in EXCEL?

[Guest]

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

 

[Paul Corrado]

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.