At 12:39 PM 6/4/01 -0700, AL.RAMOS wrote:
>I WOULD LIKE HELP ON FORMULATING DATA ON EXCEL THAT WOULD EXECUTE
>RANDOM NUMBERS WITHOUT REPEATING. I TRIED USING THE FOLLOWING FORMULA
>BUT IT REPEATS SOME OF THE NUMBERS: =RAND()*39. ONCE I ENTER THIS
>FORMULA A NUMBER SHOWS UP ON CELL A1 AND THEN I JUST DRAG TO OTHER
>CELLS AND EXCEL AUTOMATICALLY GENERATES OTHER NUMBERS BUT REPEATS SOME
>OF THEM. I NEED HELP SO THAT IT DOES'NT REPEAT THEM . THANKS. AL.
are they really random if there are never any repeats????
=================================================================
Instructions for joining and leaving this list and remarks about
the problem of INAPPROPRIATE MESSAGES are available at
http://jse.stat.ncsu.edu/
=================================================================
