how can I randomize a set of 496 numbers?

[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

 

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

 

[Gary''s Student]

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

Sort cols A&B by B

 

[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