how can I randomize a set of 496 numbers?

S

Stuart Leeman

I have a set of 496 numbers, from 1 to 496 that I have to randomize. Any
idea how to easliy do it?
Thanks
 
D

Dave Peterson

Are these in a single column range--like A1:A496?

If yes, then put:
=rand()
in B1 and drag down to B496

Then select A1:B496 and sort by column B.
 
G

Gary''s Student

Enter the values in column A
Enter:
=RAND() in B1 and copy down

Sort cols A&B by B
 
M

Mike H

Hi,

Lets assume these numbers are in column A. Put this in B1 abd drag down

=Rand()

Select columnA & Column B and sort on column B to mix up your numbers.

Mike
 
Top