how can I randomize a set of 496 numbers?
 

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

how can I randomize a set of 496 numbers?
 

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.

Stuart Leeman wrote:

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

how can I randomize a set of 496 numbers?
 

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

Sort cols A&B by B
--
Gary''s Student - gsnu200851


"Stuart Leeman" wrote:

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

how can I randomize a set of 496 numbers?
 

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

"Stuart Leeman" wrote:

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