I want to sort data randomly in addition to the current descendin.
 

That's basically it. I have existing worksheets of data that I would like to
sort in random order. There are roundabout ways to do this with formulas,
but this can be tricky, and does not work in all situations.

Can you really call putting data in a random order Sorting?

tj

"ckephart" wrote:

That's basically it. I have existing worksheets of data that I would like to
sort in random order. There are roundabout ways to do this with formulas,
but this can be tricky, and does not work in all situations.

Hi
the solution I know would invole a helper column with the formula
=RAND()
for all rows and sorting with this helper column. This should work

--
Regards
Frank Kabel
Frankfurt, Germany

"ckephart" schrieb im Newsbeitrag
...
That's basically it. I have existing worksheets of data that I would
like to
sort in random order. There are roundabout ways to do this with
formulas,
but this can be tricky, and does not work in all situations.