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

C

ckephart

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.
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top