Sorting

D

DAve Goodwin

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
 
D

Dave Peterson

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

Dave Goodwin

Thanks Dave, it always seems so simple once someone smarter than you shows you how? Thanks
 
Top