Sorting

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

Guest

I would like to randomly sort a list of numbers, from 1 to 60. I can't use a random number creation because I want no duplicates. I need only numbers from 1 through 60 randomly sorted without duplication and the ability to sort again with a different result

Thanks
 
Put 1 to 60 in A1:A60
in B1:B60, put =rand()
then sort A1:A60 by column B.

Hit F9 to recalc and then sort again and you've got a second list.
 
Thanks Dave, it always seems so simple once someone smarter than you shows you how? Thanks
 

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 you randomly assign numbers without getting duplicates? 6
Order numbers from smallest to largest 6
How do you randomly generate numbers in Excel 2007? 4
How can I sort a column of numbers generated by excel RAND funct? 5
Random Numbers 6
anaysis tookpak 4
Randomized data tables 4
Data Sorting 7

Back
Top