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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

Similar Threads

Sorting day names chronologically 5
Highest alphanumeric 6
Sorting Linked Data Between Sheets 3
how to sort a column of Randomly selected numbers? 8
Randomly sort a set group of integers 3
MACRO RUN random percentage and copy of column values 1
Data Randomization 2
random number generator 6

Back
Top