Randomly sorting an Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
Use a help column, assume the names are in A starting in A2, insert a
temporary B column and put

=RAND()

in B2, copy down by double clicking the lower right corner of the cell with
the formula, select all columns that need to be sorted and sort by the help
column, remove the help column


--


Regards,


Peo Sjoblom
 

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

how do i sort an excel spreadsheet by column 1
Selecting random names from lists 1
how to sort a column of Randomly selected numbers? 8
Excel EXCEL 2010 HELP 1
Sorting Spreadsheet Help 4
17 random numbers between 1 to 65 8
Data Randomization 2
How to make random numbers stay the same 4

Back
Top